#DateWhereItemComment
5123 Jul 2012 @ 08:28 PDTToolsEasy Loader for Teradata Parallel TransporterWhat record format are you specifying? Most formats are binary formats. How many bytes of "junk"? If 2 at the beginning of each record, then it is possible you are seeing the 2-byte record lengt...
5011 Jul 2012 @ 02:20 PDTToolsEasy Loader for Teradata Parallel TransporterPlease take a look at this thread, specifically regarding the terminal emulator code page that should be used. http://forums.teradata.com/forum/tools/tpt-multiple-instances-using-mainframe-host-sy...
4928 Jun 2012 @ 08:05 PDTToolsEasy Loader for Teradata Parallel TransporterOne thing I do see is that you have a comma after the specification of column "D" in the schema object.
4827 Jun 2012 @ 10:22 PDTToolsEasy Loader for Teradata Parallel TransporterFor the post about this: $FILE_READER: TPT19350 I/O error on file 'file1.txt'. $FILE_READER: TPT19109 Data Schema Column count (3) conflicts with columns received (0) in record 2. Please pro...
4727 Jun 2012 @ 10:14 PDTToolsEasy Loader for Teradata Parallel Transporterif you have a syntax error in the script, the best approach is to post the entire script so that someone can try to find the error.
4620 Jun 2012 @ 07:31 PDTToolsEasy Loader for Teradata Parallel TransporterThank you for providing the script. I would need to see the console output to verify that you are indeed using the Update operator. You are using a job variable for the operator name and so just ...
4520 Jun 2012 @ 11:54 PDTToolsEasy Loader for Teradata Parallel TransporterYes, TPT 13.10 supports MultipleReaders. Please consult the TPT 13.10 Users Guide.
4406 Jun 2012 @ 11:14 PDTToolsEasy Loader for Teradata Parallel TransporterIf you have a MultiLoad job script that reads from a single file and processes 2 million rows, converting that to a TPT script with a DataConnector operator and an Update operator with the same num...
4330 May 2012 @ 12:07 PDTToolsUse Teradata Parallel Transporter to Move Data Without Landing the Data to DiskWhat version of TPT are you using? We provide sample JCL when you install TPT on your mainframe.
4218 Apr 2012 @ 10:59 PDTToolsLarge Object Loading with Teradata Parallel TransporterNo. TPT will expect the data in one way or another. There is no way for TPT to know whether the data in the non-LOB data file is the file name for LOB data, or the actual LOB data. That is why y...
4118 Apr 2012 @ 10:57 PDTToolsUse Teradata Parallel Transporter to Move Data Without Landing the Data to DiskYes, you can invoke TPT via a Unix shell script like you can with FastLoad and MultiLoad. (I do not have a sample, but it would be no different than your FastLoad/MultiLoad ones.) If you alread...
4017 Apr 2012 @ 05:04 PDTToolsLarge Object Loading with Teradata Parallel TransporterIn order to load LOBs, you will need a file for each LOB column data. You then need your non-LOB data file that contains the data for the rest of the scalar data, and in the position of the colu...
3912 Apr 2012 @ 07:39 PDTToolsEasy Loader for Teradata Parallel Transportertdload (EasyLoader) generates scripts under the covers. In order to do this, we have created templates for all operators and in these templates we have assigned job variables to every supported att...
3812 Apr 2012 @ 11:53 PDTToolsEasy Loader for Teradata Parallel TransporterYes. Check the TPT Reference manual for the use of the (I think) LogonMech and LogonMechData attributes.
3712 Apr 2012 @ 11:44 PDTToolsUse Teradata Parallel Transporter to Move Data Without Landing the Data to DiskWe have an ODBC operator to extract data from Oracle. So, in the script you would define an ODBC operator and provide the DSN information and the SELECT statement. You then provide an operator fo...
3619 Mar 2012 @ 04:40 PDTToolsTeradata Parallel Transporter Supports Quoted VARTEXT in TTU14.00I wrote the article prior to the feature being implemented and I I believe it is possible that the "doubling" did not get fully functional. Thus, you will need to "escape" the quote character. ...
3527 Jan 2012 @ 01:38 PSTToolsEasy Loader for Teradata Parallel TransporterUnfortunately, I cannot stop my work in order to provide a private tutorial on TPT. This article outlines in a short amount of space, all that is needed to load data using TPT without a script. ...
3402 Dec 2011 @ 09:42 PSTToolsEasy Loader for Teradata Parallel TransporterThis question has been asked several times across several different medium. The "$" has special meaning in TPT syntax. The user is supposed to be able to enclose column names within double-quote...
3314 Nov 2011 @ 04:34 PSTToolsLarge Object Loading with Teradata Parallel TransporterPlease provide me with the contents of the file "0253B2471_parte2.new". That file must be in the proper format.
3226 Oct 2011 @ 05:37 PDTToolsUse Teradata Parallel Transporter to Move Data Without Landing the Data to DiskTPT has a concept of "directory scan" which means you can place more than one file in a directory (or "PDS" on the mainframe) and just tell us how many reader instances you want to use, and we will...
3126 Oct 2011 @ 11:59 PDTToolsEasy Loader for Teradata Parallel TransporterAll TPT users should provide a unique job name so that the checkpoint/restart files are unique. The job name is the last argument on the command line. For example: $ tbuild -f -v . . . . ...
3015 Sep 2011 @ 04:43 PDTToolsUse Teradata Parallel Transporter to Move Data Without Landing the Data to DiskDue to the nature of the parallelism of TPT, we cannot output periodic messages indicating the number of records processed, because we do not have an accurate count. User often use multiple inst...
2907 Sep 2011 @ 12:24 PDTToolsUse Teradata Parallel Transporter to Move Data Without Landing the Data to DiskAn AccountId string is optional information that is sometimes specified when an account is created. If the account is yours and you have no knowledge of an AccountId string, then there probably is ...
2818 Aug 2011 @ 11:18 PDTToolsEasy Loader for Teradata Parallel TransporterFire away whenever you want. You can also just send them to my email if you want.
2718 Aug 2011 @ 11:14 PDTToolsEasy Loader for Teradata Parallel TransporterOh, hey, I did not notice who was writing until just now! How are you? Glad to hear you are pushing TPT. Right thing to do. :)

Pages