#DateForumTypeThreadPost
403 Oct 2014 @ 02:16 PDTToolsReplyGet a Thousand Separators Using BTEQ Export Script select cast((CAST(COALESCE(TRIM(a.salary),'                    ') as DECIMAL(19,2)) (FORMAT...
303 Oct 2014 @ 12:02 PDTToolsTopicGet a Thousand Separators Using BTEQ Export Script (FORMAT 'G999999999D99' ) Hi I am using BTEQ script to export the data returned by a query (say like below) to a file called sample.txt sel salary from employee Now I am getting the...
207 Jun 2012 @ 03:52 PDTDatabaseTopicrecursive function Hi One of my SQL is failing with the below error.I tried using cast function also.But it is not working.here the coli1,col2,col3 are CHAR fileds and the id is DECIMAL(38,0). Can any one ...
107 Jun 2012 @ 03:20 PDTToolsReplyNumeric overflow Hi I am facing the numeric overflow error with the below query. Error:  *** Failure 2616 Numeric overflow occurred during computation.       &nbs...