#DateForumTypeThreadPost
35906 Nov 2012 @ 02:32 PSTToolsReplyWhy I am getting "Load Operator: TPT10306: Error 5 retrieving attribute 'LogTable' error"?If you would consult the TPT manuals regarding the Load operator, you would notice that the LogTable attribute is a mandatory attribute. You did not supply a table name for the log table.  
35806 Nov 2012 @ 02:31 PSTToolsReplyUse TPT to load a million flat filesHave you tried using more than 2 instances of the file reader? What version of TPT are you using?  
35731 Oct 2012 @ 04:42 PDTToolsReplyLoading using Teradata Parallel Transporter Load utility.Re: the post about the 2 columns and loading all of the data into a single column: TPT has a feature whereby you indicate in the schema a column that is a metadata column specifically for the file...
35631 Oct 2012 @ 04:18 PDTToolsReplyMulti load through java application.There is no Java/JDBC interface to the MultiLoad protocol.
35531 Oct 2012 @ 04:14 PDTToolsReplyFast Export Restart LogWhy do you want to know what information is being stored in the FastExport restart log table? That information is only important to FastExport. As for setting checkpoints, one cannot normally che...
35431 Oct 2012 @ 04:09 PDTToolsReplyLoading using Teradata Parallel Transporter Load utility.Did you try a record format of "unformatted" instead of "binary"?
35319 Oct 2012 @ 10:38 PDTToolsReplyTPT Instances - How this works?The UNION ALL is to get the parallelism from the producer operator side. When sending the rows to the consumer operator (the Update operator in your case), the data is not sent in a round robin fa...
35218 Oct 2012 @ 11:26 PDTToolsReplyUsing templates for operators provided in TPTAll of our docs for all releases are in the same place. Thus, if you can see the TPT 13.00 docs, you should be able to see the TPT 13.10 docs. http://www.info.teradata.com/  
35117 Oct 2012 @ 12:58 PDTToolsReplyUsing templates for operators provided in TPTOk, spoke with the engineer: Explicit schema association via the statement                 SELECT * FROM OPERATOR ($EXPO...
35015 Oct 2012 @ 06:18 PDTToolsReplyTPT API and TLOGVIEWBTW, if you are unhappy with the level and detail of statistical and error reporting by the ETL tool, please inform the vendor. We try to push from our end. It helps if the push also comes from the...
34915 Oct 2012 @ 06:16 PDTToolsReplyTPT API and TLOGVIEWI do not disagree with you in principle. However, with TPTAPI, we are just providing the operators to an application so that they have direct control over them. In the original design, with the ori...
34815 Oct 2012 @ 05:58 PDTToolsReplyUsing templates for operators provided in TPTPlease provide me with the contents of the job variable file. When we take the script sample from the very first post (and provide our own values for the job variables), we do not get the same issu...
34715 Oct 2012 @ 05:55 PDTToolsReplyUsing templates for operators provided in TPTBased on the script in the very first post, if that is indeed the script you submitted, please remove the single quotes from around the countries_SCHEMA after the $EXPORT.  
34615 Oct 2012 @ 05:46 PDTToolsReplyUsing templates for operators provided in TPTSnippet is not wrong. I was unaware of that new syntax enhancement. Please provide the entire (real) script (not the snippet from the manual).  
34515 Oct 2012 @ 05:28 PDTToolsReplyTPT12120 error in TPT export operator I looked up the TPT12120 error. It states: "Order By clause and Multiple Instances are mutually exclusive"   This is pretty obvious. Your SELECT statement has an ORDER BY clause ...
34415 Oct 2012 @ 05:22 PDTToolsReplyTPT12120 error in TPT export operator Please post the script, and the entire output from the job.  
34315 Oct 2012 @ 03:20 PDTToolsReplyTPT API and TLOGVIEWOk. I will try to explain why those tool are not available for TPTAPI. Those tools are only available for the script-based TPT because the operators are controlled by a TPT infrastructure (a set o...
34212 Oct 2012 @ 10:59 PDTToolsReplyUsing templates for operators provided in TPTI am not sure this will totally solve the problem, but you should not be putting a table name after the $INSERT.
34110 Oct 2012 @ 07:02 PDTToolsReplyTPT19350 I/O error on filePlease provide all messages that are being reported in the log. There might be other messages that explain why the TPT19350 was reported. The version of TPT and platform would also be helpful. &...
34010 Oct 2012 @ 06:57 PDTToolsReplyError while loading through tdloadPretty difficult to offer assistance when no other information is provided. At a minimum, I would need to know the version of TPT that is installed. Have you tried to provide the password on the ...
33908 Oct 2012 @ 05:01 PDTToolsReplyLoading carriage returns with TPT Load OperatorNo. It did not make it in to 14.0 or 14.10. We will look into this as a post-14.10 activity.  
33821 Sep 2012 @ 02:43 PDTToolsReplyTableWait on Update Operator in TPTWe do not yet have the TABLEWAIT feature in the Update operator. It is on the list of features to add.  
33719 Sep 2012 @ 02:21 PDTToolsReplyNotify Routine for Update only using EVEN Table positionsThis issue was fixed in 14.0 (efix #4). That fix will be applied to 13.10 and 13.0 a little bit later this year.  
33614 Sep 2012 @ 02:16 PDTToolsReplyUsing MACROCHARSET in TPTRemove the "CASESPECIFIC" keyword. It is not part of the syntax.  
33512 Sep 2012 @ 04:01 PDTToolsReplySpecial Characters in Columnnames in FastExport I just tried created a table with a CHAR(10) column and populated it with the string "$_abc". I then exported the data from that table to a file and the contents of that column wer...

Pages