#DateForumTypeThreadPost
75927 Oct 2014 @ 06:50 PDTToolsReplyTPT multiple instances using mainframe host (Syntax error).It appears as though your installed TPT components are not in sync with each other. The error is telling you that the message catalog is not the correct one for the installed version of TPT (a com...
75827 Oct 2014 @ 06:46 PDTToolsReplyFLOAD Script throws error "TPT_INFRA: At "select" missing SEMICOL_ in rule: Job Definition Body"This is not a FLOAD job. This is a TPT job. The error message you are getting is a syntax error. In order to help you, you need to provide the entire script. You are either missing a semicolon s...
75715 Oct 2014 @ 05:58 PDTToolsReplyLoad qouted data with delimiter chanrater in valuesYes you can with MultiLoad. But not with version 13.0. I believe the first version with the "quoted data" feature was 14.0. The MultiLoad Reference Manual will have the commands necessa...
75608 Oct 2014 @ 03:44 PDTToolsReplyTPT19434 pmOpen failedThis post does not say much. What is the job trying to do? What version of TPT are you using? Can you provide a copy of the TPT script? Can you provide the rest of the console output?  
75502 Oct 2014 @ 12:31 PDTToolsReplyEXPORT_OPERATOR: TPT12108: Output Schema does not match data from SELECT statementTPTAPI is the method by which ETL vendors (and other applications) use TPT to load data into Teradata. We publish the API and provide the operators so that applications can call our libraries/oper...
75401 Oct 2014 @ 07:29 PDTToolsReplyTPT script to load data with embedded qualifiersNo. Parsing rules are the same.
75301 Oct 2014 @ 06:55 PDTToolsReplyLimitation of Reading number of Fields in TPTWe should (in theory) be able to read in that many fields, and I will definitely have someone look into this. What version of TPT are you running? Can you also post a screenshot of the console ou...
75201 Oct 2014 @ 02:57 PDTToolsReplyQuoted qualifiers in TPTPlease refer to this thread: https://forums.teradata.com/forum/tools/tpt-script-to-load-data-with-embedded-qualifiers Embedded quotes must be escaped.  
75101 Oct 2014 @ 02:34 PDTToolsReplyTPT script to load data with embedded qualifiersThat field will have to be modified. That record will be a problem because it does not adhere to our parsing rules. (You cannot have it both ways. You cannot indicate that you want your data quot...
75001 Oct 2014 @ 01:41 PDTToolsReplyTPT script to load data with embedded qualifiersYour attributes look fine. But there have to be parsing rules. They are not complex, but they exist so that delimited data can be parsed correctly. You cannot expect to have quoted data with emb...
74901 Oct 2014 @ 12:06 PDTToolsReplyTPT script to load data with embedded qualifiersIf your data is not quoted, we will process everything in between the delimiters as data. If you are using the delimited feature "QuotedData" and you have embedded quotes inside the quot...
74829 Sep 2014 @ 01:03 PDTToolsReplyEXPORT_OPERATOR: TPT12108: Output Schema does not match data from SELECT statementUnfortunately, I am not familiar with Informatica and cannot provide any information for setting options.   And I believe Informatica uses TPTAPI, which means there is no script to modify. ...
74724 Sep 2014 @ 01:13 PDTToolsReplyTPT scriptsUpdate: please upgrade to the latest patch. I believe it is 14.10.00.06.
74624 Sep 2014 @ 11:15 PDTToolsReplyTPT scriptsFirst, was you intent to use the MultipleReaders feature? If so, then please upgrade to the latest patch for 14.10. If not, then please do not set that attribute.  
74524 Sep 2014 @ 10:33 PDTToolsReplyTPT - BUFFERMAX errorIs the data delimited format? The DC operator can continue processing under certain conditions when processing delimited data. If some records will have too many columns or too few columns (than ...
74422 Sep 2014 @ 06:04 PDTToolsReplyFacing TPT error while lading data from flat file to Teradata Not sure what "next day I reviewed and got the same problem" means. "Reviewing" does not mean "fixing".   This script has several issues. First, please remove...
74322 Sep 2014 @ 05:20 PDTToolsReplyGetting error on Fastload..."nvalid state for Load"Yes, once the error tables are dropped, the job must start from the beginning, meaning you must drop and recreate the target table.  
74222 Sep 2014 @ 05:16 PDTToolsReplyRestarting Fastload if we have error with the source data fileNo, if everything is done correctly, you are actually NOT supposed to drop the error tables in order to restart a job that was paused. Dropping the error tables (and the row in the restart log tabl...
74122 Sep 2014 @ 05:01 PDTToolsReplyTeradata FLOAD error table 1 creates unwanted newlines in Dataparcel data.Whenever you upgrade to a new version of TTU, always go to the patch server and look for the latest patches (inevitably, by the time people get around to upgrading, new patches are available). In f...
74012 Sep 2014 @ 09:34 PDTToolsReplyTeradata FLOAD error table 1 creates unwanted newlines in Dataparcel data.Please explain what you mean by: "Currently, the data generated from each Data Parcel"?   Who is generating the data? If the source data was in delimited format, then FastLoad wil...
73903 Sep 2014 @ 03:23 PDTToolsReplyTPT User TemplatesUser defined templates must reside in the same directory as the ones we provide. The directory is protected because most system administrators do not want the installed ones to be modified since t...
73803 Sep 2014 @ 03:18 PDTToolsReplyTPT Extract not working for column name starting with FROM_ As always, it would be helpful if you could post the version of TPT you are running and a copy of the script.  
73703 Sep 2014 @ 11:54 PDTToolsReplyExporting to Multiple files in Fast ExportI do not believe the -C (uppercase) existed in 13.0. (And 13.0 is not a supported release of our TTU software as of July 2014.)  
73602 Sep 2014 @ 10:17 PDTToolsReplyExporting to Multiple files in Fast ExportThe lowercase -c is not what you think it is.  :) What version of TPT are you using? The only reason why rows were distributed when exporting 13.3 million is because there was enough work to...
73528 Aug 2014 @ 09:20 PDTToolsReplyEasy Loader IssueThis was by design. (It is the way the script-based TPT works as well.) If you would like the restart log table to be created somewhere else, you must be explicit in the table name (add database q...

Pages