#DateForumTypeThreadPost
113403 Jun 2016 @ 01:26 PDTToolsReplyFast Export Error - UTY8400 Error determining ESS support, code = 224A CLI224 means the DBC name (tdpid) was not found in the hosts file (/etc/hosts).
113303 Jun 2016 @ 11:24 PDTToolsReplyTPT API C program usageI could be wrong, but I think he wanted to know the performance difference between a TPT-script job using the Export operator versus a TPTAPI job using the Export operator.   Script-based TP...
113203 Jun 2016 @ 10:02 PDTToolsReplyTPT API C program usage1. As I indicated above, the column names need to be provided. 2. We have not performed any performance characterizations to compare performance between a TPTAPI application and script-based TPT. ...
113102 Jun 2016 @ 06:41 PDTToolsReplyTPT Statement Not Working: DEFINE SCHEMA <SchemaName> FROM TABLE '<TableName>';BTW, I did not want to throw too much at you at one time. The script I provided can be made even shorter, by moving all of the attribute settings into the job variable file, and having you use pre-...
113002 Jun 2016 @ 06:16 PDTToolsReplyTPT Statement Not Working: DEFINE SCHEMA <SchemaName> FROM TABLE '<TableName>';Before I can provide the final answers, can you please share the table DDL with me? I have a suspicion about what is happening, but would like to look at the table definition anyway.   I be...
112902 Jun 2016 @ 10:50 PDTToolsReplyTPT API C program usage1. No. You need to provide the column names. 2. You can either retrieve a row at a time from the Export operator, or you can call GetBuffer to get a 64K buffer of rows. Repeated calls to GetRow or...
112801 Jun 2016 @ 03:05 PDTToolsReplyASCII value of the delimiter in TPT Export OperatorI just found out that we actually do support "OpenQuoteMarkHex" and "CloseQuoteMarkHex" attributes. They are not documented (mainly because we wanted to revamp how we support h...
112701 Jun 2016 @ 11:48 PDTToolsReplyTPT and Windows PowerShell"tbuild" is actually a link to a program called "tptlaunch" that does some environment setup and then calls "tbuildexe.exe". Users should never attempt to run tbuilde...
112631 May 2016 @ 12:50 PDTToolsReplyNeed Help regarding TPT ODBC OperatorData does not get duplicated across the output files. The file writer instances will each be given a unique block to write out. Because it is round-robin, if you have 3 file writer instances, the...
112531 May 2016 @ 12:47 PDTToolsReplyTPT Data StreamsThe data stream lives on your PC. It uses virtual memory. The data does not go across the wire to th Teradata Database until the Load operator sends the data buffers to the data sessions.  
112431 May 2016 @ 12:45 PDTToolsReply TPT03036: Length must be a positive integer valueWell, without seeing the entire script and SELECT statement I can only guess what the syntax would look like.   Single-quotes need to be escaped if they appear in a job variable or attribute...
112331 May 2016 @ 12:42 PDTToolsReplyASCII value of the delimiter in TPT Export OperatorAh yes, sorry about that. My mistake. If "vi" converts the TAB to spaces, then you would have to find another way to get the real TAB character into the string. We do not currently inter...
112231 May 2016 @ 12:40 PDTToolsReplyExecuting multiple TPT scripts simultaneously will yield to better perfomance?The use of: APPLY TO OPERATOR (tpt_writer1) SELECT * FROM OPERATOR (tpt_reader1); APPLY TO OPERATOR (tpt_writer2) SELECT * FROM OPERATOR (tpt_reader2); APPLY TO OPERATOR (tpt_writer3) SELE...
112127 May 2016 @ 03:48 PDTToolsReplyError limit in TPT's STREAMStarting in 15.00, the Stream operator will output the same stats for the error table to the console output, similar to what is done for the Load and Update operators.   The information is a...
112026 May 2016 @ 04:24 PDTToolsReplyNeed Help regarding TPT ODBC OperatorDoes the data have to go to a single output file? Can you write to multiple output files? If so, then use multiple instances of the DataConnector Consumer and the -C command line option to round-...
111926 May 2016 @ 03:44 PDTToolsReplyUsing TPT templates to copy more than one table in a script.Well, a few things, but we will take them one step at a time. By using the "simplified" script language and "templates", the idea is for TPT to generate the schema for you. An...
111826 May 2016 @ 01:50 PDTToolsReplyASCII value of the delimiter in TPT Export OperatorThere is an undocumented attribute called TextDelimiterHex. Enter the hex values for those 2 characters. The attribute is a VARCHAR attribute so put the hex values in single quotes.  
111726 May 2016 @ 12:02 PDTToolsReplyTPT Statement Not Working: DEFINE SCHEMA <SchemaName> FROM TABLE '<TableName>';I guess I should have been more specific. Please provide the job variable file. And just to confirm, the script is exactly the same as you posted above, but you are now not getting the first erro...
111625 May 2016 @ 10:12 PDTToolsReplyTPT Statement Not Working: DEFINE SCHEMA <SchemaName> FROM TABLE '<TableName>';I will need more information. Same script? Is there a job variable file? Still 14.10.00.02?
111525 May 2016 @ 06:55 PDTToolsReplyTPT Statement Not Working: DEFINE SCHEMA <SchemaName> FROM TABLE '<TableName>';Which issue do you want me to address: This one: TPT_INFRA: At ";" missing { DBMS_ LIBRARY_ LOG_ LOGGER_ OPERATOR_ SCHEMA_ SYSTEM_ TABLE_ WORKING_ } in Rule: Non-Executable Statement &...
111424 May 2016 @ 04:28 PDTToolsReplyASCII value of the delimiter in TPT Export OperatorDid you try pressing the TAB key on your keyboard?  
111320 May 2016 @ 12:26 PDTToolsReplyTPT: Target Database different than Working Database with LOAD operatorProvide a fully qualified tablename (including the database name) for the TargetTable attribute (and/or corresponding job variable).  
111219 May 2016 @ 02:47 PDTToolsReplyFEXP_OPERATOR: TPT12108: Output Schema does not match data from SELECT statementAnd remove this from the Export operator definition:     VARCHAR ErrorTable = 'DB_LOG.BEPS_fxlog', It is not being used; it is being ignored, but it should not be there. T...
111119 May 2016 @ 02:46 PDTToolsReplyMLOAD - UTY4014 Access module error '43' received during 'set position' operationNotice this line: **** 12:01:06 UTY6210 Logtable 'TEST_DWH_LOG.ML_CuenBEPS_1' indicates that a      restart is in progress.   So, you may think they are all ne...
111019 May 2016 @ 02:41 PDTToolsReplyNeed Help regarding TPT ODBC OperatorYes, there is a way. The syntax is (roughly, you will have to refer to the manual for the exact syntax):      APPLY TO OPERATOR ($FILE_WRITER)    SELECT * FROM ($ODBC A...

Pages