#DateForumTypeThreadPost
723 Sep 2015 @ 08:00 PDTToolsTopicShared job limit in BTEQ scriptHi,   Can we set a limit on BTEQ script to not to run the script when  its running state,we have one bteq script thats running dialy with different params  , but some times when tw...
623 Nov 2014 @ 08:00 PSTDatabaseTopicTeradata Pivot I have a requirement where i need to implement pivot to achieve below result.   Source: EMP_ID,Date,Seq_nbr,Punch 123,20-nov-2014,1,08:20 123,20-nov-2014,2,12:50 123,20-nov-2014,1,14:12 ...
511 Jul 2014 @ 12:35 PDTGeneralTopicHow to use reserved key words as column namesHi ,   I have to use the Teradata reserved key word "DEC" as a column name in my calender table, If i specify this word in double quotes(" DEC ") working fine. Any alter...
401 Jul 2013 @ 01:05 PDTDatabaseTopicHow to get columns in collect statsHi,   in my project few of the tables have collect stats on some columns... Could you guys let me know how to get on what tables having collect stats on what fields???
306 Jun 2013 @ 04:24 PDTDatabaseReplyHelp needed on recursive sqlThanks .. working fine
206 Jun 2013 @ 04:20 PDTDatabaseTopicConvert string into dateHi ,   Could you  please suggest me how to convert the string value '4/6/2013' to date, string value coming in different formats 4/6/2013 12/6/2013 6/12/2013
102 Jun 2013 @ 03:21 PDTDatabaseTopicHelp needed on recursive sqlHi ,    i have an table its having four fields cost,retail,units,weekdayyr. sample data is given below. cost,retail,units,weekdayofyr 120,125,100,1 115,132,142,1 114,859...