#DateForumTypeThreadPost
1302 Sep 2016 @ 06:04 PDTDatabaseReplyInsert taking longHi Dieter, thanks I will try to make all tables as multiset and will try to make another column as Primary Index. Thanks Sir..  
1231 Aug 2016 @ 11:34 PDTDatabaseTopicInsert taking longHi Gurus,   I have the below script everything works well but at the bottom of the script we have insert in to statement ie for UDRBSCMS.RCD_TPB_OVERALL_DECISION and its taking ages to ...
1131 Aug 2016 @ 11:25 PDTToolsReplyMULTILOAD BUFFER ERROR!!! urgentHi Ivyuan,   thanks for getting back to me. Acutally there was issue with the tab space. we had extra tab hence the column got shifted to other and so forth...now its resolvd.
1025 Aug 2016 @ 12:13 PDTToolsTopicMULTILOAD BUFFER ERROR!!! urgentHi All,   I am trying to load the 8 mil rows into the target table and when I try to insert into target table then I get the below issue   * 16:46:18 UTY1802 Processing Import Sequ...
921 Aug 2016 @ 04:13 PDTDatabaseReplyPadding and timestampthank all ...it worked like charm L:)  
818 Aug 2016 @ 07:28 PDTDatabaseTopicPadding and timestampHi All,   I have a column with the format column x and beow are the values.  10/1/15 4/1/16 7/1/15 I want to convert the same into 2015-01-10 00:00:00 and same for others. I wan...
716 Aug 2016 @ 05:28 PDTDatabaseReplySQL query needed---UrgentThanks all :) I wil try both codes...Nice to have SQL gurus....:) world lack them
615 Aug 2016 @ 10:23 PDTDatabaseTopicSQL query needed---UrgentHi All, I have source data as Month         x                   y Aug 14     3000           &n...
515 Aug 2016 @ 07:46 PDTToolsReplyCasting Date in Bteq utilitiesHi Fred, thank you very much for your inputs howver I have tried to create the staging table with the below query and used oTranslate funcion to pad 0 if its single digit    substri...
409 Aug 2016 @ 07:39 PDTDatabaseTopicconvert varchar data into timestampHi All, can you please help me with this   I am trying to convert below varchar records into timestamp.    2016-08-03 8:32:03 2016-08-03 11:56:34   Tried mul...
309 Aug 2016 @ 07:34 PDTDatabaseReplyConvert text to a timestampHi All I am trying to convert  2016-08-03 8:32:03 2016-08-03 11:56:34  which are in varchar to timestamp. can you please help me
209 Aug 2016 @ 04:34 PDTToolsReplyCasting Date in Bteq utilitiesHi Team, can anyone let me know syntax to convert date as above in fastload instead of bteq plzz
108 Aug 2016 @ 10:38 PDTToolsTopicCasting Date in Bteq utilitiesHi Team,   I am new to Teradata  and I have a requirement to load the data FROM EXCEL using BTEQ UTILITIY. However as far as I know we cannot load data from excel but can load in CSV fo...