459 | 05 Jul 2013 @ 10:00 PDT | Tools | Reply | Executing 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... |
458 | 03 Jul 2013 @ 12:17 PDT | Tools | Reply | TPT 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... |
457 | 26 Jun 2013 @ 07:28 PDT | Tools | Reply | Using templates for operators provided in TPT | MultipleReaders only applies to flat files.
There is no way for multiple processes to read from a single pipe.
|
456 | 26 Jun 2013 @ 01:56 PDT | Tools | Reply | Parallel Transporter | Yes. In the root install directory for TPT, there is a twbcfg.ini file and you can redefine the directories in there.
|
455 | 19 Jun 2013 @ 12:28 PDT | Tools | Reply | Fastload issues with decimal column | On 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... |
454 | 19 Jun 2013 @ 12:26 PDT | Tools | Reply | How to load EBCDIC file to db using TPT? | All of our load products can only load EBCDIC data from MVS/zOS.
|
453 | 18 Jun 2013 @ 09:38 PDT | Tools | Reply | How 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.)
|
452 | 31 May 2013 @ 04:32 PDT | Tools | Reply | TPT 64bit on Windows 7 sits on FINISH indefinitely | The 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... |
451 | 31 May 2013 @ 02:50 PDT | Tools | Reply | TPT 64bit on Windows 7 sits on FINISH indefinitely | What 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... |
450 | 31 May 2013 @ 01:21 PDT | Tools | Reply | TPT 64bit on Windows 7 sits on FINISH indefinitely | Are you really talking about TPTAPI?
Or about the Wizard?
(For TPTAPI, you have to write an application to drive the TPT operators.)
|
449 | 31 May 2013 @ 11:15 PDT | Tools | Reply | TPT 64bit on Windows 7 sits on FINISH indefinitely | Script-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... |
448 | 31 May 2013 @ 08:59 PDT | Tools | Reply | TPT 64bit on Windows 7 sits on FINISH indefinitely | 64-bit TPT has not been released yet.
|
447 | 23 May 2013 @ 10:34 PDT | Tools | Reply | Teradata PT 12.0 error output schema does not match | Script-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... |
446 | 06 May 2013 @ 10:57 PDT | Tools | Reply | bteq export and import for _ET dataparcel | The 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.... |
445 | 06 May 2013 @ 03:47 PDT | Tools | Reply | bteq export and import for _ET dataparcel | Even 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 ... |
444 | 06 May 2013 @ 10:39 PDT | Tools | Reply | bteq export and import for _ET dataparcel | The tool is still in development. There is no release date yet.
|
443 | 23 Apr 2013 @ 02:15 PDT | Tools | Reply | TPT19350 I/O error on file | You 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... |
442 | 22 Apr 2013 @ 02:39 PDT | Tools | Reply | TPT19350 I/O error on file | You have specified a record format of "formatted".
Are you sure your data file adheres to the required format?
|
441 | 17 Apr 2013 @ 12:35 PDT | Tools | Reply | TPT + Named pipes | TPT requires the file names in the -f option be a physical disk file.
|
440 | 08 Apr 2013 @ 06:26 PDT | Tools | Reply | Strange Errorcode in TPT error table | Did you really obtain that information from executing a SELECT statement against the error table? Normally, the content of the "DataParcel" field is not legible.
|
439 | 08 Apr 2013 @ 01:21 PDT | Tools | Reply | Using name of Flat File in TPT Load | Right now, the METADATA feature is only supported with a record format of DELIMITED.
|
438 | 21 Mar 2013 @ 11:59 PDT | Tools | Reply | Improving Loading Mechanism using Fastload | Yes. TPT supports it.
Please refer to the TPT documentation (user guide).
|
437 | 18 Mar 2013 @ 10:42 PDT | Tools | Reply | SQL_SELECTOR: TPT15105: Error 13 in finalizing the table schema definition | Well, 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.
|
436 | 18 Mar 2013 @ 06:01 PDT | Tools | Reply | SQL_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... |
435 | 18 Mar 2013 @ 11:20 PDT | Tools | Reply | Tpump Error, Invalid session mode | The user cannot change the session mode.
TPump will always run in Teradata mode.
|