#DateForumTypeThreadPost
23405 Jan 2012 @ 05:45 PSTToolsReplyTPT13103: Error 5 retrieving DML Group Attribute If you get a message that "<table-name> is being loaded" it means you started a job and it somehow terminated in an unknown state. It usually means that there are sessions still ...
23305 Jan 2012 @ 05:42 PSTToolsReplyData byte count error To answer your first question: http://developer.teradata.com/tools/articles/selecting-the-right-operator-to-use-for-your-tpt-job   To answer your 2nd question: TPTAPI is wri...
23204 Jan 2012 @ 12:07 PSTToolsReplyTPT variables in script itself (Providing a default value that could then be overridden) Yes, you should be able to use the job variables anywhere.
23126 Dec 2011 @ 04:18 PSTToolsReplyData byte count error You cannot use the Export operator to export data in Delimited format. You need to use the Selector operator and make sure ReportMode is set to 'yes'.  
23026 Dec 2011 @ 04:16 PSTToolsReplyTPT13103: Error 5 retrieving DML Group Attribute Your APPLY statement does not have a DML group. You need an INSERT statement for the Load operator. It should be:   APPLY (    'INSERT INTO . . . . ;&#...
22920 Dec 2011 @ 04:55 PSTToolsReplyTPT_INFRA: TPT01015: Error: Failed to allocate a lock to synchronize access to internal message queue This means you have run out of system resources. How many instances of the operators are you using? Probably too many.  
22815 Dec 2011 @ 01:14 PSTToolsReplyTeradata TPT Script Ok, looked a little further and that error message does not look like it comes from TPT. Also, in the environment setup you showed me earlier, from what file was that text?  
22715 Dec 2011 @ 12:16 PSTToolsReplyTeradata TPT Script Just want to make sure that when you ssh to the remote system, you indeed pick up the correct environment. I have searched through the code and do not see that particular error message, but ...
22615 Dec 2011 @ 11:45 PSTToolsReplyProblem using RowErrFileName Upgrade to the latest patch for 13.10, which should be 13.10.00.07. That should fix this problem.  
22514 Dec 2011 @ 06:47 PSTToolsReplyMLOAD Error - An invalid statement was found before the .LOGON statement Well, we have tried this inhouse and do not have any problems with:   .logtable  . . . . ; .run file . . . . ; .set maxerror . . . ; database . . . ;   ...
22414 Dec 2011 @ 01:41 PSTToolsReplyTDLoad Hangs when invoked from Python Sorry. I do not have an answer for you. I also do not know who is putting out the very last message, "Teradata Load Utility Version 13.10.00.07". It is not a normal TPT message...
22314 Dec 2011 @ 01:37 PSTToolsReplyTeradata TPT Script Are you sure the entire environment is set up correctly? Did you make sure that TWB_ROOT is set up and is available in the environment from the Java app that is connecting to the remote mach...
22213 Dec 2011 @ 03:55 PSTToolsReplyTPT DATA CONNECTOR CONSUMER BEHAVING DIFFERENT IN MAINFRAME V/S MIDRANGE/WINDOWS regarding EOR. For #4, mainframe I/O is always different from Unix and Windows. Mainframe datasets are record oriented. Not so on Unix and Windows. For #5, the number of records does not limit the use of t...
22112 Dec 2011 @ 01:43 PSTToolsReplyTDLoad Hangs when invoked from Python What is different between the "simple" python program and the "complicated" one? If you can get TPT to run from within a "simple" python program, I fail to see ...
22009 Dec 2011 @ 04:10 PSTToolsReplyTPT DATA CONNECTOR CONSUMER BEHAVING DIFFERENT IN MAINFRAME V/S MIDRANGE/WINDOWS regarding EOR. A couple of things. 1. always provide the version of TPT you are using; we cannot offer any assistance with that information 2. FastExport will always write out a 2-byte length in front ...
21909 Dec 2011 @ 02:42 PSTToolsReplyTPT Licnese on Unix Server You will have to talk to whomever is in charge of your licenses and purchases. I do not think our licenses are on a "per-server" or "per-cpu" type of use. I believe once ...
21809 Dec 2011 @ 11:20 PSTToolsReplyTeradata TPT Script TPT is not yet supported on Mac OS X. That effort is planned (but not committed) for 4Q12. TdpId/Username/UserPassword is the only mechanism by which TPT can connect to Teradata. As ...
21709 Dec 2011 @ 11:13 PSTToolsReplyTPT Licnese on Unix Server Not sure why you installed TPT on your Teradata box. TPT needs to be installed on your load servers.
21609 Dec 2011 @ 09:58 PSTToolsReplyTPT - How to format records with fixed length fields () The TPT documentation explains the different record formats we support. Look in the Reference Manual in Chapter 4 for the Data Connector operator (that operator is the file reader). You will...
21509 Dec 2011 @ 09:51 PSTToolsReplyTPT - Problem loading delimited data with multiple files That patch has been out for quite a while.
21408 Dec 2011 @ 07:34 PSTToolsReplytpt export import Our documentation is on the official Teradata Information website. http://www.info.teradata.com/ As for patches, you will have to discuss with your rep about accessing Teradata At Your Servi...
21308 Dec 2011 @ 07:29 PSTToolsReplyNeed Help on using TPT with UNICODE characters Ok, I will work backwards. The first thing to understand is that TPT and the older legacy standalone utilities do the exact same thing. It is called following (and executing) a particula...
21208 Dec 2011 @ 11:28 PSTToolsReplyTeradata TPT Script You have 2 choices. 1. use Easy Loader (executable is called "tdload"); in TTU 14.0 we allow you to supply the source table name and target table name (and logon credentials for ea...
21108 Dec 2011 @ 11:14 PSTToolsReplyTPT - Problem loading delimited data with multiple files We will support "gz" and "zip" in TTU14.0. Also, you should consider upgrading to the latest and greatest efix patch for 13.10. I believe the latest version is 13.10....
21007 Dec 2011 @ 01:46 PSTToolsReplyTPT - Problem loading delimited data with multiple files Please provide me with the "exact" version of the 13.10 release. This may be an issue we fixed and if I know which version you are running, I can tell you if the fix came in a patc...

Pages