#DateForumTypeThreadPost
330 Aug 2016 @ 10:13 PDTAnalyticsReplyIS-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...
228 Jul 2016 @ 11:20 PDTDatabaseReplySet 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...
126 Jul 2016 @ 01:31 PDTToolsReplyExport with header using TPTAs 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...