#DateForumTypeThreadPost
45905 Jul 2013 @ 10:00 PDTToolsReplyExecuting FastLoad Protocol on TPT with Flat files with VARIABLE COLUMN NUMBERS What version of TPT are you using? TPT supports "long" rows and "short" rows. If you provide a schema in the TPT script that matches the target table, you can then specify &qu...
45803 Jul 2013 @ 12:17 PDTToolsReplyTPT Instances - How this works?We do support the use of multiple instances reading from a single file. We have seen some nice performance improvement (due to the operating system caching the I/O reads). However, YMMV. As far as...
45726 Jun 2013 @ 07:28 PDTToolsReplyUsing templates for operators provided in TPTMultipleReaders only applies to flat files. There is no way for multiple processes to read from a single pipe.  
45626 Jun 2013 @ 01:56 PDTToolsReplyParallel Transporter Yes. In the root install directory for TPT, there is a twbcfg.ini file and you can redefine the directories in there.  
45519 Jun 2013 @ 12:28 PDTToolsReplyFastload issues with decimal columnOn the mainframe, the data is stored in packed decimal format. On non-mainframe platforms, the data is most likely stored in scaled integer format (Teradata's internal format). This might acc...
45419 Jun 2013 @ 12:26 PDTToolsReplyHow to load EBCDIC file to db using TPT?All of our load products can only load EBCDIC data from MVS/zOS.  
45318 Jun 2013 @ 09:38 PDTToolsReplyHow to load EBCDIC file to db using TPT?On which version of z/OS are you running? (We only support loading EBCDIC data on the mainframes.)  
45231 May 2013 @ 04:32 PDTToolsReplyTPT 64bit on Windows 7 sits on FINISH indefinitelyThe Wizard does not suppport JRE 7. I do not even think it supports 6. The last version I know of that worked was 5.x (and I would have to find out what the 'x' was). We are trying to imp...
45131 May 2013 @ 02:50 PDTToolsReplyTPT 64bit on Windows 7 sits on FINISH indefinitelyWhat version of the JRE are you running? BTW, we would rather you just create a script and run it from the command line. We will be discontinuing the Wizard (not sure when) and we are not fixing a...
45031 May 2013 @ 01:21 PDTToolsReplyTPT 64bit on Windows 7 sits on FINISH indefinitelyAre you really talking about TPTAPI? Or about the Wizard? (For TPTAPI, you have to write an application to drive the TPT operators.)  
44931 May 2013 @ 11:15 PDTToolsReplyTPT 64bit on Windows 7 sits on FINISH indefinitelyScript-based TPT is only 32-bit (until a bit later this year when we release an update to 14.10 that will contain 64-bit TPT). The 4 operators you see listed as 64-bit is because we offer 64-bit v...
44831 May 2013 @ 08:59 PDTToolsReplyTPT 64bit on Windows 7 sits on FINISH indefinitely64-bit TPT has not been released yet.
44723 May 2013 @ 10:34 PDTToolsReplyTeradata PT 12.0 error output schema does not matchScript-based TPT does not currently enable the user to write out data to files on different Unix nodes. The "faking" out reference was an ability to read data with different schemas, and...
44606 May 2013 @ 10:57 PDTToolsReplybteq export and import for _ET dataparcelThe data in the varbyte does not have the delimiter. We do not send "delimited" data to Teradata. We process the delimited data and send the row to Teradata as a series of VARCHAR fields....
44506 May 2013 @ 03:47 PDTToolsReplybteq export and import for _ET dataparcelEven though the data is in a binary format, the only reason why it is stored in a VARBYTE is so that the endianness character set encoding is preserved. The data itself is in the exact format that ...
44406 May 2013 @ 10:39 PDTToolsReplybteq export and import for _ET dataparcelThe tool is still in development. There is no release date yet.  
44323 Apr 2013 @ 02:15 PDTToolsReplyTPT19350 I/O error on fileYou should read the documentation to understand the various formats that we support, and then when creating that file, make sure to create it with one of the supported formats. Our own tools (obvi...
44222 Apr 2013 @ 02:39 PDTToolsReplyTPT19350 I/O error on fileYou have specified a record format of "formatted". Are you sure your data file adheres to the required format?  
44117 Apr 2013 @ 12:35 PDTToolsReplyTPT + Named pipesTPT requires the file names in the -f option be a physical disk file.
44008 Apr 2013 @ 06:26 PDTToolsReplyStrange Errorcode in TPT error tableDid you really obtain that information from executing a SELECT statement against the error table? Normally, the content of the "DataParcel" field is not legible.  
43908 Apr 2013 @ 01:21 PDTToolsReplyUsing name of Flat File in TPT Load Right now, the METADATA feature is only supported with a record format of DELIMITED.
43821 Mar 2013 @ 11:59 PDTToolsReplyImproving Loading Mechanism using FastloadYes. TPT supports it. Please refer to the TPT documentation (user guide).
43718 Mar 2013 @ 10:42 PDTToolsReplySQL_SELECTOR: TPT15105: Error 13 in finalizing the table schema definitionWell, without seeing the entire script, what you have shown me is a Selector operator retrieving 2 DECIMAL columns and a VARCHAR. Therefore, your schema must match.  
43618 Mar 2013 @ 06:01 PDTToolsReplySQL_SELECTOR: TPT15105: Error 13 in finalizing the table schema definition@ericsun2: the schema must match the data. Thus the Selector is retrieving 2 DECIMALs and a VARCHAR. Your schema does not match that. And yes, if you are using a client session character set of UT...
43518 Mar 2013 @ 11:20 PDTToolsReplyTpump Error, Invalid session modeThe user cannot change the session mode. TPump will always run in Teradata mode.

Pages