#DateForumTypeThreadPost
73428 Aug 2014 @ 09:14 PDTToolsReplyExporting to Multiple files in Fast ExportUse the -C (uppercase) on the command line to round-robin the records to the files.
73321 Aug 2014 @ 05:07 PDTToolsReplyExporting to Multiple files in Fast ExportNot with FastExport. But you can do this with TPT.   Multiple .begin export/.end export are executed sequentially.  
73220 Aug 2014 @ 11:58 PDTToolsReplyTPT scriptsTPT only loads Teradata.  
73119 Aug 2014 @ 06:04 PDTToolsReplyTPT_INFRA TPT01057 Error Insufficient main storage for attempted allocationGranted we do not document the maximum number of steps that someone can place into a single TPT job, but I am sure we do not really advocate the amount you are trying.   It is all about syst...
73018 Aug 2014 @ 09:24 PDTToolsReplyTPT - Scripts from 13.10 doesn't work with 15.10 using named pipesEfixes are not shipped to the Developer Exchange. They are available on the patch server.  
72914 Aug 2014 @ 05:23 PDTToolsReplyTPT_ISSUEIn the script, I will need you to add an attribute to the DataConnector operator definition, as:   VARCHAR TraceLevel = 'all'   and re-run the job that fails and send me the ....
72811 Aug 2014 @ 05:26 PDTToolsReplyTPT - Scripts from 13.10 doesn't work with 15.10 using named pipesThat is a known issue and has been fixed in these versions of TPT:   13.10.00.19 14.00.00.12 14.10.00.05 15.00.00.02  
72711 Aug 2014 @ 10:50 PDTToolsReplyFast load ErrorWhen in doubt, please read the manual. The "File" specification is part of the DEFINE statement. You have the BEGIN LOADING command in between the DEFINE and the "File". And ...
72608 Aug 2014 @ 10:17 PDTToolsReplyFASTEXPORT LoopingIf the "FastExport.txt" file contains FastExport commands, then this cannot be run through BTEQ. A file that is used in the RUN FILE command in a BTEQ script, must contain only BTEQ comm...
72508 Aug 2014 @ 09:24 PDTToolsReplyFASTEXPORT LoopingIt would help to know the contents of the FastExport.txt script.  
72407 Aug 2014 @ 01:11 PDTToolsReplyFASTEXPORT LoopingWhat would you like the IF ELSE condition to accomplish?
72307 Aug 2014 @ 11:57 PDTToolsReplyXML data format support by the TPT DataConnector OperatorIf by volume you mean system capacity, you would need to check with the administrator or perhaps the documentation for whatever the provider is.  
72205 Aug 2014 @ 02:56 PDTToolsReplyTPT extract failing - TPT10508: RDBMS error 5407: Invalid operation for DateTime or IntervalNot much information to work with here. Version of TPT? Version of Teradata? Copy of the SELECT statement? DDL of the source table?  
72128 Jul 2014 @ 07:07 PDTToolsReplyTPT in Red Hat Linux - Dumping core We do not normally test with client boxes in a cluster. We are trying to emulate the environment to see if we can duplicate the issue.  
72026 Jul 2014 @ 09:01 PDTToolsReplyTPT load failure - Please suggestYes, it is possible that the actual "provider" of the driver is Informatica, even though the drivers themselves are manufactured by DataDirect.   I was just trying to make sure bec...
71926 Jul 2014 @ 10:52 PDTToolsReplyTPT : Suppress or Redirect stdout/stderr logsI believe TPT supports the -o command line option to write out the "console" output to a file. The redirection works just fine as well.   That console output is just a "brief&...
71824 Jul 2014 @ 09:19 PDTToolsReplyTPT load failure - Please suggestOk, just verified with development. The fix to this problem is in efix #5 (you are running with efix #4). Please upgrade to 14.10.00.05.  
71724 Jul 2014 @ 08:42 PDTToolsReplyTPT load failure - Please suggestThe drivedr indicates it is from "Informatica". Can you provide some information about that driver? Is it DataDirect? Also, when you indicated you used a different operator to connect ...
71623 Jul 2014 @ 03:17 PDTToolsReplyTPT 14.10 problems loading data from SQL Server using TPT WizardThis was a known issue with 64-bit TPT and the Microsoft ODBC driver. It was fixed in 14.10.00.03. However, I see that you are using 14.10.00.04, so this is baffling. I would need y...
71523 Jul 2014 @ 03:17 PDTToolsReplyTPT load failure - Please suggestThis was a known issue with 64-bit TPT and the Microsoft ODBC driver. It was fixed in 14.10.00.03. However, I see that you are using 14.10.00.04, so this is baffling. I would need y...
71421 Jul 2014 @ 09:45 PDTToolsReplyIssues with TPT when escape character comes in the dataPlease provide the script. What version of TPT are you using? What operator are you using for the export?
71316 Jul 2014 @ 11:37 PDTToolsReplyFastload Problem: Invalid Fastload StatementYou say you are stuck, but do not give the problem. I do see 2 things: 1. you still have not removed the checkpoint command; that is not valid 2. I do not believe you can provide CAST or FORMAT ...
71216 Jul 2014 @ 11:32 PDTToolsReplyTPT - LOAD TWO FIELDS IN ONE COLUMN (concatenate)It is possible. You need to define 2 schemas. One as the input schema for the DataConnector operator and one as the output schema for the DataConnector operator.   Something like:   D...
71115 Jul 2014 @ 09:59 PDTToolsReplyFastload Problem: Invalid Fastload StatementThis error is not related to an error tables. The problem is with your "checkpoint 1000" statement. That is not valid. You specify the checkpoint interval on the BEGIN LOADING command....
71010 Jul 2014 @ 08:08 PDTToolsReplyQuestion on Failed TPT LoadIt depends on the reason for the failure. Some "failures" can be fixed by the user so that the job can be restarted. You also do not say which operators you had used in the job. That i...

Pages