#DateForumTypeThreadPost
818 Sep 2015 @ 12:53 PDTToolsReplyFastExport Remove Binary/Indicator Values in Outmod Thanks for the response... I did wind up going the route of casting as CHAR(32000)... But did so begrudgingly :).  I guess it's easier to truncate white space than to solve this riddle wi...
718 Sep 2015 @ 10:32 PDTToolsTopicFastExport Remove Binary/Indicator Values in Outmod Hi, This is an old question, and I believe the only solution to be an outmod, but I have never coded one (linux environment).  I am actually exporting SQL (from DBQL).  BTEQ will not hon...
609 Feb 2015 @ 02:17 PSTDatabaseReplyIdentifying the Target of an IUD (insert/update/delete) OperationI have Tom, and that isn't off the table. Our need is particular, basically to audit entire systems of ETL SQL (thousands of queries a day). Taking the data off of Teradata and parsing, is an o...
509 Feb 2015 @ 09:02 PSTDatabaseReplyIdentifying the Target of an IUD (insert/update/delete) OperationRelease 14.10.  I am working on parsing, and have a general direction.  But, REGEXP functions have been pretty flaky.  One of the first steps (in my eyes) is to remove comments. &nbs...
406 Feb 2015 @ 10:06 PSTDatabaseTopicIdentifying the Target of an IUD (insert/update/delete) OperationWe have a need to identify the target table/object of on insert/update/delete operation... ideally through DBQL where it can be tied to querybands.  The closest (potential) field that may have...
319 Jul 2013 @ 04:53 PDTToolsReplyTPT and Unix/Linux Environment VariablesThat's good to hear about TD15.  The -u should suffice for our immediate needs, but there are unix/linux command line length limits so file paths and such could stretch those limits. The ...
203 Jul 2013 @ 02:19 PDTToolsTopicTPT and Unix/Linux Environment VariablesIs there a way, within a TPT module, to accept in OS environment variables? I am aware of the global variable file (good for all modules) and the local variable file (good for a particular module)...
101 Apr 2013 @ 11:09 PDTUDAReplyRaise Error and Return value with in a stored procedureIs there a link to download RaiseSQLSTATE?  I have worked with it (very successfully) on systems that have it, but cannot find it on this site?