159 | 17 Aug 2011 @ 01:34 PDT | Tools | Reply | TPT multiple instances using mainframe host (Syntax error). | Ok, we just tried this in house with efix #4 (13.10.00.04) and it works for us without any syntax problems.
Therefore, please post the entire script.
There must be something else wrong with the s... |
158 | 17 Aug 2011 @ 11:49 PDT | Tools | Reply | Problem using RowErrFileName | For this particular output you sent me, the job terminated because of this:
LOAD_OPERATOR: preparing target table
LOAD_OPERATOR: TPT10508: RDBMS error 3803: Table 'ET_Trans' already exists.
... |
157 | 17 Aug 2011 @ 11:06 PDT | Tools | Reply | TPT multiple instances using mainframe host (Syntax error). | Thanks for bringing this up. I will forward to the dev team for analysis.
|
156 | 10 Aug 2011 @ 12:15 PDT | Tools | Reply | TPT 13.10 tbuild export operator on HP itanium | This is a regression that has already been found and is being fixed.
We put the fix in the upcoming 14.0 release and are going to efix/patch it to 13.10 as well.
If you would like a D2D, to try o... |
155 | 10 Aug 2011 @ 11:59 PDT | Tools | Reply | Notify TPT ODBC Operator | Please read the documentation. The documentation explicitly states what types of information are supported.
The Notify feature is to capture and report events while loading (or exporting) data.
S... |
154 | 10 Aug 2011 @ 11:55 PDT | Tools | Reply | Problem using RowErrFileName | Please be more specific about "TPT goes to FatalError and crashes".
Please provide a snapshot of the output you are seeing.
Please also provide the version of TPT that you are using.
|
153 | 04 Aug 2011 @ 05:28 PDT | Tools | Reply | Problem ODBC OPERATOR | Your schema does not look like it is matching the data being returned from SQLServer.
The schema from the source table has to VARCHARs and a FLOAT.
But your script schema has 3 CHARs.
Your scrip... |
152 | 04 Aug 2011 @ 03:56 PDT | Tools | Reply | Double-byte handling in TPT | To answer your delimiter question, if you are trying to do something that we do not support, then yes you would need to use an INMOD to covnert the data into a format we understand. Or change the d... |
151 | 04 Aug 2011 @ 03:47 PDT | Tools | Reply | Double-byte handling in TPT | TPT is only "certified" with the ODBC drivers from DataDirect.
There are some customers who have had success using other drivers such as Oracle's (11g) or Microsoft's (not much though) and it is... |
150 | 04 Aug 2011 @ 03:45 PDT | Tools | Reply | Notify TPT ODBC Operator | The Notify feature does not work with the ODBC operator.
The Notify feature only works with the Load, Update, Export and Stream operators.
This is because the Notify feature was originally supp... |
149 | 04 Aug 2011 @ 03:28 PDT | Tools | Reply | TPT_ISSUE | If you are running a version as old as 12.00.00 (which, by the way is not a supported versin of TPT), please upgrade to the latest and greatest efix patches.
As for this command:
tbuild -f /h... |
148 | 04 Aug 2011 @ 02:27 PDT | Tools | Reply | TPT and compression | In 14.00.00, we are adding support for handling gzip files. But not for mainframe just yet (technical issues).
However, that is just for handling data that arrives to TPT as compressed data.
That... |
147 | 04 Aug 2011 @ 11:24 PDT | Tools | Reply | TPT ERROR CODE TPT_INFRA: TPT02040 | In the JCL for running the TPT job, add "REGION=0M" after "EXEC PGM=TBUILD" which allows the address space to be given as much virtual space as possible |
146 | 27 Jul 2011 @ 06:08 PDT | Tools | Reply | TPT with FASTLOAD INMOD on z/OS - Error TPT_INFRA: TPT01036 | Ok, I spoke to our mainframe expert on the TPT team and he indicated that there are several bug fixes since the GCA version and that coredump may be one of them. He suggests that you (the customer)... |
145 | 27 Jul 2011 @ 03:09 PDT | Tools | Reply | TPT with FASTLOAD INMOD on z/OS - Error TPT_INFRA: TPT01036 | The first thing I can respond with (and I am not a mainframer by any stretch of the imagination) is that you should upgrade to the latest and greatest efix patch. I see that you are at the base GCA... |
144 | 27 Jul 2011 @ 02:28 PDT | Tools | Reply | Teradata PT 12.0 error output schema does not match | That error message seems to indicate that the "exporting" operator (the producer operator) appears to have coredumped for some reason.
I would need more information than just that one line to bett... |
143 | 27 Jul 2011 @ 12:22 PDT | Tools | Reply | skip the header row in the flat file, when importing using FastLoad script | FastLoad does not have the ability to skip header rows.
FastLoad is always looking for records in an input file to adhere to the layout in the DEFINE statement. |
142 | 20 Jul 2011 @ 08:16 PDT | Tools | Reply | Fast Load Error - Record is too long by n byte(s) | Even though his example only showed one column, he did indicate the data would be CSV. Therefore, I would not use SET RECORD TEXT.
And SET RECORD TEXT cannot take a delimiter character.
|
141 | 20 Jul 2011 @ 03:20 PDT | Tools | Reply | Double-byte handling in TPT | The version of TPT that you are using does not support scenarios where the delimiter character can be part of the data.
We are enhancing TPT's handling of delimited data, but even with the new i... |
140 | 14 Jul 2011 @ 01:01 PDT | Tools | Reply | While running TBUILD Script from informatica command line below error displaying.Can some body suggest resolution | That version of TPT is not supported anymore.
Please upgrade to a supported version of TPT. |
139 | 14 Jul 2011 @ 11:39 PDT | Tools | Reply | Header skipping while data loading using fastload | The RECORD command in FastLoad is used to skip valid records in a file.
FastLoad does not support the skipping of header rows that are not valid data rows. |
138 | 15 Jun 2011 @ 11:33 PDT | Tools | Reply | Where can I download the Teradata Parallel Transport API for all platforms? | Since a license is needed for TPTAPI you need to get it through the same channels as you would get FastLoad, MultiLoad, and TPT.
The TTU packages are available for all platforms, not just Windows.
|
137 | 01 Jun 2011 @ 03:20 PDT | Tools | Reply | How to call TPT scripts from Shell Scripts | I am not sure what the -d option is, or why you would want to use it, but the tbuild command takes the script file as an input argument using the -f command line option.
Therefore, in a shell sc... |
136 | 18 May 2011 @ 11:27 PDT | Tools | Reply | TPT with mainframe Varible block file | Please send any and all information.
Version of TPT.
JCL.
Script.
All output. |
135 | 18 May 2011 @ 11:00 PDT | Tools | Reply | Using name of Flat File in TPT Load | The feature is not available in TPT12.0.
It was added to TPT13.0. |