#DateForumTypeThreadPost
2211 Aug 2016 @ 05:28 PDTToolsTopicteradata utilities doesn't work with python on MacHi, I installed TTU 14.10 on my Mac. When I execute the command from shell like bteq, tbuild etc., it works fine. When I invoke the same command from python, it fails.   >>> my_cmd...
2126 May 2016 @ 12:13 PDTToolsTopicError limit in TPT's STREAMHi All,   I want to capture rows skipped due to Errors from STREAM operator. I see that this is not captured in STREAM in the way it is done for LOAD. I just get the following message. STRE...
2011 May 2016 @ 01:03 PDTToolsReplyTPT without schema for STREAM OperatorI got it working by specifying table name after $INSERT macro. I didn't find this information in the user guide document. I had to try different options to get it working. SO the final script i...
1911 May 2016 @ 11:43 PDTToolsReplyTPT without schema for STREAM OperatorI get the following error.  Teradata Parallel Transporter Version 14.10.00.10  TPT_INFRA: TPT04129: Error: No DBS table name could be associated with the   $INSERT macro in ...
1810 May 2016 @ 10:31 PDTToolsReplyTPT without schema for STREAM OperatorI had tried both ways and neither of them worked. Coming to the main question, is it possible to templatize STREAM operator based loading?
1710 May 2016 @ 10:05 PDTToolsReplyTPT without schema for STREAM OperatorI don't want to provide values because I want to template the control file and be able to use it for any table. For example, I used following LOAD script that I can use for any table by passing...
1610 May 2016 @ 08:04 PDTToolsReplyTPT without schema for STREAM OperatorI don't use the job variable file. Complete script is same as the original post except that I have removed INTEGER keyword.  I am still pasting the complete script and the console output....
1509 May 2016 @ 05:55 PDTToolsReplyTPT without schema for STREAM OperatorYes, thanks. That error is gone now. However, I am facing following error after I have made that change to the script.    $STREAM: TPT16102: An error occurred while submitting the follo...
1409 May 2016 @ 02:49 PDTToolsTopicTPT without schema for STREAM OperatorHi All, With TTU 14, we could create templates for TPT without the need to specify SCHEMA definition. I was able to successfully implement it for EXPORT, SELECTOR and LOAD operator. However, I am ...
1329 Jan 2015 @ 02:48 PSTToolsReplyTPT - BUFFERMAX errorYes, thank you.
1229 Jan 2015 @ 09:51 PSTToolsReplyTPT - BUFFERMAX errorHi, In continuation to this, I want to make use of a file list that contains list of compressed files ( .gz files ). Would I be able to load .gz files using the file list ?   Regards, Nave...
1106 Jan 2015 @ 11:36 PSTToolsReplyTPT - BUFFERMAX errorOk, thanks. It worked on TTU 14.10.00.07.
1006 Jan 2015 @ 10:09 PSTToolsReplyTPT - BUFFERMAX errorI tested the same script on another version of tbuild, and it seems to work as expected there.  Teradata Parallel Transporter Version 13.10.00.05 But its not working on a higher version o...
905 Jan 2015 @ 11:46 PSTToolsReplyTPT - BUFFERMAX errorTPT version is  tbuild -V Teradata Parallel Transporter Version 14.10.00.02  
805 Jan 2015 @ 11:45 PSTToolsReplyTPT - BUFFERMAX errorI am trying to load only one line. File has only this line, with new line character at the end. 1234|1234  
705 Jan 2015 @ 08:07 PSTToolsReplyTPT - BUFFERMAX errorYes it does. I tried without the file list and even that throws the same error. Thanks, Naveen K
605 Jan 2015 @ 06:21 PSTToolsReplyTPT - BUFFERMAX errorHi,   I get the same error when I try to update the last field of a table to the file name. I am trying to load the files in a file list. Please find below my TPT script.   DEFINE JO...
523 Apr 2010 @ 11:48 PDTDatabaseReplyTeradata Metadata ServicesThanks for the reply. How do we track dependencies for database objects? Could you please explain in detail? Thanks
424 Mar 2010 @ 09:44 PDTDatabaseTopicTeradata Metadata ServicesHi All, Could you please explain me about Teradata Metadata Services? What are its uses ? Also , is it possible to find the dependancy of table in Teradata like to know the procedures and vie...
327 Feb 2010 @ 11:02 PSTDatabaseTopicInserting space as value from a char column to varchar columnHi All, I have a case where-in i need to insert space as a value for a column which is declared as char from 1 table to another column in another table which is declared as varchar. When I t...
208 Aug 2009 @ 07:18 PDTDatabaseReplySql to delete duplicates in TeradataHi emilwu, I don't think we can ordered analytical functions in the where clause. Regards, Naveen K
107 Aug 2009 @ 07:27 PDTDatabaseTopicSql to delete duplicates in TeradataHi , Is there a single SQL statement to delete duplicate records from a table in Teradata. Note , I don't want to use any intermediate table , like inserting into an intermediate set table. ...