# | Date | Forum | Type | Thread | Post |
8 | 18 Sep 2015 @ 12:53 PDT | Tools | Reply | FastExport 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... |
7 | 18 Sep 2015 @ 10:32 PDT | Tools | Topic | FastExport 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... |
6 | 09 Feb 2015 @ 02:17 PST | Database | Reply | Identifying the Target of an IUD (insert/update/delete) Operation | I 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... |
5 | 09 Feb 2015 @ 09:02 PST | Database | Reply | Identifying the Target of an IUD (insert/update/delete) Operation | Release 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... |
4 | 06 Feb 2015 @ 10:06 PST | Database | Topic | Identifying the Target of an IUD (insert/update/delete) Operation | We 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... |
3 | 19 Jul 2013 @ 04:53 PDT | Tools | Reply | TPT and Unix/Linux Environment Variables | That'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 ... |
2 | 03 Jul 2013 @ 02:19 PDT | Tools | Topic | TPT and Unix/Linux Environment Variables | Is 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)... |
1 | 01 Apr 2013 @ 11:09 PDT | UDA | Reply | Raise Error and Return value with in a stored procedure | Is 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?
|
|
|