#DateForumTypeThreadPost
15917 Aug 2011 @ 01:34 PDTToolsReplyTPT 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...
15817 Aug 2011 @ 11:49 PDTToolsReplyProblem using RowErrFileNameFor 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. ...
15717 Aug 2011 @ 11:06 PDTToolsReplyTPT multiple instances using mainframe host (Syntax error).Thanks for bringing this up. I will forward to the dev team for analysis.
15610 Aug 2011 @ 12:15 PDTToolsReplyTPT 13.10 tbuild export operator on HP itaniumThis 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...
15510 Aug 2011 @ 11:59 PDTToolsReplyNotify TPT ODBC OperatorPlease 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...
15410 Aug 2011 @ 11:55 PDTToolsReplyProblem using RowErrFileNamePlease 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.
15304 Aug 2011 @ 05:28 PDTToolsReplyProblem ODBC OPERATORYour 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...
15204 Aug 2011 @ 03:56 PDTToolsReplyDouble-byte handling in TPTTo 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...
15104 Aug 2011 @ 03:47 PDTToolsReplyDouble-byte handling in TPTTPT 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...
15004 Aug 2011 @ 03:45 PDTToolsReplyNotify TPT ODBC OperatorThe 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...
14904 Aug 2011 @ 03:28 PDTToolsReplyTPT_ISSUEIf 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...
14804 Aug 2011 @ 02:27 PDTToolsReplyTPT and compressionIn 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...
14704 Aug 2011 @ 11:24 PDTToolsReplyTPT ERROR CODE TPT_INFRA: TPT02040In 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
14627 Jul 2011 @ 06:08 PDTToolsReplyTPT with FASTLOAD INMOD on z/OS - Error TPT_INFRA: TPT01036Ok, 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)...
14527 Jul 2011 @ 03:09 PDTToolsReplyTPT with FASTLOAD INMOD on z/OS - Error TPT_INFRA: TPT01036The 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...
14427 Jul 2011 @ 02:28 PDTToolsReplyTeradata PT 12.0 error output schema does not matchThat 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...
14327 Jul 2011 @ 12:22 PDTToolsReplyskip the header row in the flat file, when importing using FastLoad scriptFastLoad 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.
14220 Jul 2011 @ 08:16 PDTToolsReplyFast 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.
14120 Jul 2011 @ 03:20 PDTToolsReplyDouble-byte handling in TPTThe 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...
14014 Jul 2011 @ 01:01 PDTToolsReplyWhile 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.
13914 Jul 2011 @ 11:39 PDTToolsReplyHeader skipping while data loading using fastloadThe 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.
13815 Jun 2011 @ 11:33 PDTToolsReplyWhere 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.
13701 Jun 2011 @ 03:20 PDTToolsReplyHow to call TPT scripts from Shell ScriptsI 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...
13618 May 2011 @ 11:27 PDTToolsReplyTPT with mainframe Varible block filePlease send any and all information. Version of TPT. JCL. Script. All output.
13518 May 2011 @ 11:00 PDTToolsReplyUsing name of Flat File in TPT Load The feature is not available in TPT12.0. It was added to TPT13.0.

Pages