# | Date | Forum | Type | Thread | Post |
3 | 30 Aug 2016 @ 10:13 PDT | Analytics | Reply | IS-NUMERIC functions |
I know is to late.
Regex could be a good option.
Consider the value is not a number then a default value can set and the "SQLSTATE 22023 Invalid character x in number str... |
2 | 28 Jul 2016 @ 11:20 PDT | Database | Reply | Set unix variable inside bteq |
Hi Srinivas,
There is possible use environment variables and have a "clean" script (bteq, tpt, or whatever.), perl are very useful.
Firs... |
1 | 26 Jul 2016 @ 01:31 PDT | Tools | Reply | Export with header using TPT | As Steve says there are not an attribute to get file with columns header.
Many times i used one of two options:
1 - Use OS COMMAND to concatenate two files, headers file and export file. On windo... |
|
|