#DateForumTypeThreadPost
108428 Apr 2016 @ 04:20 PDTToolsReplyTPT_INFRA: TPT01036: Error: Task (TaskID: 5, Task Name: SELECT_2[0001]) terminated due to the receipt of signal number 11Jose1: what version of TPT are you using? Always download the latest and greatest patch for that version, and if the problem still exists, then post. And please provide as much information as possi...
108328 Apr 2016 @ 11:29 PDTToolsReplyASCII value of the delimiter in TPT Export OperatorThe warning is evident in the console output (sometimes it is in the log, but this time it is on the console).   o_ExportOper: RDBMS Warning: 3705 Request executed in interpretive EVL mod...
108227 Apr 2016 @ 10:58 PDTToolsReplyASCII value of the delimiter in TPT Export OperatorYou must consider a '4' as successful. It is the only way that the Teradata Client Load/Unload products can inform the user that there was a warning. Our products have been working this way...
108126 Apr 2016 @ 06:09 PDTToolsReplyTPT api UpdateDriver why fail ??TD DBS is at version 13.10. What version of TPTAPI are you using? "create error table" is not something that TPTAPI would submit, so that is probably coming from your application. Anot...
108026 Apr 2016 @ 07:30 PDTToolsReplyASCII value of the delimiter in TPT Export OperatorThere is no limit on the number of columns that can be processed by the Export operator. It can handle whatever Teradata supports. What is the version of TPT and the version of the Teradata Datab...
107922 Apr 2016 @ 09:26 PDTToolsReplyASCII value of the delimiter in TPT Export OperatorThere is an undocumented attribute called TextDelimiterHex that allows you to enter the hex values for a delimiter. The helps when the delimiter is an ASCII unprintable character.  
107821 Apr 2016 @ 12:28 PDTToolsReplyASCII value of the delimiter in TPT Export OperatorThe Export operator is not involved in the writing of data to the file. That is the job of the DataConnector operator. If you want a "tab" character, then try putting "TAB" (a...
107720 Apr 2016 @ 04:57 PDTToolsReplySuppressing TPT warningsNo, there is currently no way to suppress warnings. An exit code of '4' should be treated the same as a '0'. It is a successful job.  
107620 Apr 2016 @ 04:55 PDTToolsReplyTPT script generator and PDCR query to find AJII can only address #1. First, what version of TPT will you be using? If something new, like TPT 15.10, you can have a general purpose script, like this: DEFINE JOB export_to_file ( ...
107515 Apr 2016 @ 06:26 PDTToolsReplyTPTEXP - TPTLOAD - using Named pipe hanging at step 'EXPORT_OPERATOR: connecting sessions'No. We do not have any benchmarks. The different APIs usually serve different purposes.  
107415 Apr 2016 @ 05:35 PDTToolsReplyTPTEXP - TPTLOAD - using Named pipe hanging at step 'EXPORT_OPERATOR: connecting sessions'What version of the User Guide were you looking at? I am looking at the 14.10 TPT User Guide and see no reference to PTS00029 in it. And TPT did not support HDFS in 14.10.  
107314 Apr 2016 @ 07:35 PDTToolsReplyTPT Error loading CSV as Double QuotesThe Inserter operator is like loading with BTEQ. The Inserter operator sends a row at a time with SQL Inserts. If you want to emulate FastLoad you need to use the Load operator. If you are readi...
107214 Apr 2016 @ 05:26 PDTToolsReplyTPT Error loading CSV as Double QuotesI will be able to look at this tomorrow (I will take your script and run it on my machine). What version of TPT, and on which platform, are you running?   Unrelated, but an observation: Wh...
107114 Apr 2016 @ 03:26 PDTToolsReplyTPT Error loading CSV as Double QuotesYou have a few options. If you would like the header file to be read in and sent to the DBS, you will need to increase the size of the offending column. In other words, if the failure is on the 3...
107014 Apr 2016 @ 09:45 PDTToolsReplyTPT issue : not able to open the data fileNext, it might be best to start a new thread, as your question does not really pertain to "not able to open the data file". However, you asked a good question. If you do not provide a v...
106911 Apr 2016 @ 04:34 PDTToolsReplyTPTEXP - TPTLOAD - using Named pipe hanging at step 'EXPORT_OPERATOR: connecting sessions'I am not sure if this will help you, but the DataConnector operator can pull data from Hadoop. It can extract directly if you are trying to use HDFS. If you need other methods, then we to integra...
106811 Apr 2016 @ 02:38 PDTToolsReplyTPTEXP - TPTLOAD - using Named pipe hanging at step 'EXPORT_OPERATOR: connecting sessions'Yes, the Named Pipe will work when using FastExport, and TPT Load because you have a process writing to a pipe and a process reading from a pipe. In your script example, you have an Export operato...
106711 Apr 2016 @ 12:33 PDTToolsReplyTPTEXP - TPTLOAD - using Named pipe hanging at step 'EXPORT_OPERATOR: connecting sessions'Please explain what you mean by trying to use the Named Pipe. If you want to export rows from a Teradata table and load them into another, there is no need for Named Pipes. You just use the Expor...
106611 Apr 2016 @ 10:10 PDTToolsReplyExporting CSV from TPTThe default for the Export operator is 1 per available AMP. Unlike FastExport that defaults to 4. (We could not have a default of '4' when we support multiple instances, and all of the op...
106530 Mar 2016 @ 04:20 PDTToolsReplyfast export and mload with unicode column type and valueOnly the CHAR/VARCHAR sizes are doubled. It is only the character data that is affected. Not numeric. So, it is 18+62000+18+2000=64036. And even the DECIMAL fields will be less than 18. I think ...
106430 Mar 2016 @ 03:50 PDTToolsReplyfast export and mload with unicode column type and valueYou can copy the data if you use a character set of UTF16. You cannot do it with character set UTF8.  
106330 Mar 2016 @ 03:25 PDTToolsReplyMLOAD will not read in null timestampsIs the input data in delimited format? Did you mean you want to read an entire "row" of null timestamps? Please give a sample schema (do not need the entire script -- yet) and sample da...
106230 Mar 2016 @ 11:19 PDTToolsReplyHow to extract the count for source & target records in TPTThere is no option to TPT to automatically generate a script in readable form. You must use the tlogview command. However, we added a way to do that from within a script. We provide a $JOBID mac...
106123 Mar 2016 @ 03:19 PDTToolsReplyTPT BranchingThere are no updates or committed releases for the Conditional Job Steps feature.  
106023 Mar 2016 @ 03:16 PDTToolsReplyTeradat TPT attributes to export data to a delimited file where data from individual column is enclosed in quotesWhat version of TPT are you running? Hopefully, at least 14.10. In the DataConnector Consumer operator list of attributes, make sure QuotedData is set to 'yes'. Whether you use the Expor...

Pages