#DateForumTypeThreadPost
1313 Jun 2016 @ 03:27 PDTGeneralReplyMerge with TIMESTAMP column PKSorry its OK, the problem was i was trying to merge the same data, i update the info to merge and there no problem
1213 Jun 2016 @ 02:48 PDTGeneralTopicMerge with TIMESTAMP column PKHi everyone. I need to merge some data what i  have a 3 column's UPI (col1,col2,col3), col 1 and col2 are a varchar but col3 it's a timestamp. Im trying to merge but teradata studio ...
1124 May 2016 @ 12:54 PDTDatabaseReplyTIPS TO CONVERT DECIMAL TO VARCHARGood morning! I did the last try today with your answer and it works!!! I used the another cast option and tpt export Thanks so much for your help Dieter!!
1023 May 2016 @ 04:43 PDTDatabaseReplyTIPS TO CONVERT DECIMAL TO VARCHAROne last thing I need to replace dot for comma in numbers and i use this select: SelectStmt = 'SELECT cast(substr(col1,1,9) as varchar(9)) as col1, col2,col3,col4, col5, col6, oreplace(trim(c...
923 May 2016 @ 03:18 PDTDatabaseReplyTIPS TO CONVERT DECIMAL TO VARCHAROmg i didnt realise about that, i have thousands things in my mind and i dindt think about this. Thanks so much Dieter, it works.  
823 May 2016 @ 01:58 PDTDatabaseReplyTIPS TO CONVERT DECIMAL TO VARCHARHi Dieter, thanks for your answer. Your tip works, and i can make a good select, but in the select statement in my tpt i insert the select what i test on Teradata Studio and show me this error: &...
720 May 2016 @ 03:59 PDTDatabaseTopicTIPS TO CONVERT DECIMAL TO VARCHARHi everyone, i need help with something (Im noob using TD, and sorry my english) I´m trying to prepare a tpt script to export some data to a delimited file In the table i have columns in de...
606 May 2016 @ 02:58 PDTDatabaseReplyTips to convert data on TPTThere´s no problem, we choose another option, we make a temp table of full varchar and insert there all the data. Finally with a procedure, we format correctly the data to insert them on fin...
505 May 2016 @ 03:24 PDTDatabaseReplyTips to convert data on TPTI think the mask what you give me on the Formatout clause its the native mask on TD. There´s not problem. Using this tip what you give me TPT have the following error: TPT10679 Error: MONT...
405 May 2016 @ 01:26 PDTDatabaseReplyTips to convert data on TPTHi Carlos thanks for your help I didnt use before vardate to insert data, i need a formatout clause I was using this to insert my timestamp data on Apply zone: :DATE(TIMESTAMP(0),FORMAT '...
304 May 2016 @ 04:56 PDTDatabaseTopicTips to convert data on TPTHi everyone, i need load some data from a csv file to a teradata table using TPT. I´m having some troubles on a field what has the following mask in the table: DD/MM/YYYYBHH:MI The problem ...
215 Apr 2016 @ 04:06 PDTGeneralReplyTimestamp ERROR: 6760Hi everyone, i solved this problem, i will put the code what i used for that in the APPLY ZONE:  APPLY         (          ...
114 Apr 2016 @ 04:00 PDTGeneralTopicTimestamp ERROR: 6760Hi everyone, im trying to load some data using TPT to Teradata table. I am having troubles on column what uses TIMESTAMP(0) format, and his mask is 'DD/MM/YYYY HH:MI:SS' or 'DD/MM/YYYY...