#DateForumTypeThreadPost
65920 May 2014 @ 09:50 PDTToolsReplyTPT API : Setting DSNName attribute through TPT API script for a source databaseThe error I see is this:   TPT_INFRA: TPT01036: Error: Task (TaskID: 5, Task Name: SELECT_2[0001]) terminated due to the receipt of signal number 11 TPT_INFRA: TPT01037: Error: Task (TaskI...
65819 May 2014 @ 11:41 PDTToolsReplyDifference Between Load & Export UtilitiesOne small correct (sorry Todd!): The TPT equivalent of FastLoad is "TPT Load". TPT Insert is equivalent to BTEQ inserts (uses SQL sessions).
65719 May 2014 @ 10:40 PDTToolsReplyTPT API : Setting DSNName attribute through TPT API script for a source databaseYOu either provide the DSNName, UserName and UserPassword, or you provide the entire connection string (with proper syntax and options) in the ConnectString attribute. Do not do both. I believe the...
65616 May 2014 @ 10:24 PDTToolsReplyTPT API : Setting DSNName attribute through TPT API script for a source databasePlease check the documentation. You specified: ODBCInstances            = 1, ODBCPrivateLogName  = 'ABC.txt', ConnectS...
65512 May 2014 @ 05:30 PDTToolsReplyFastLoad ErrorThe TEXT format is for character/text data. That data normally does not have indicator bytes (just an observation of your BEGIN LOADING statement). However, the issue is most likely that you do n...
65408 May 2014 @ 11:41 PDTToolsReplyNeed help on TPTAs the message says, the operator you are using does not support the loading of LOBs. Only the SQL Inserter supports the loading of LOBs. (This is a database restriction, not a TPT restriction.) ...
65306 May 2014 @ 09:09 PDTToolsReplyTeradata TPT ScriptThe errors you are getting are from the ODBC driver. Not TPT. I cannot help with that. You will have to contact the ODBC team (or start a new thread with a better subject line so ODBC people will ...
65205 May 2014 @ 06:00 PDTToolsReplyTeradata TPT ScriptWhen you start a new job, the error tables cannot exist. Neither can the restart log table. On a restart, the error and restart log tables must exist. If a job fails and it failed for a reason t...
65105 May 2014 @ 03:23 PDTToolsReplyTeradata TPT ScriptAny database object name with special characters must be enclosed in double-quotes. That is a DBS rule. I am not sure what you mean by #5. The user does not worry about the restart log table. You...
65005 May 2014 @ 01:58 PDTToolsReplyTeradata TPT ScriptThe "@" syntax is used when you want to specify job variables. You can hardcode a value fot eh attribute (not recommended). Or you use the "@" syntax, provide a job variable n...
64905 May 2014 @ 12:58 PDTToolsReplyTeradata TPT ScriptFor the FileName attribute, you either place the name of the file, or if there is more than one, you can use wildcard syntax. Yes, from the Perl script, you just execute the "tbuild" com...
64805 May 2014 @ 12:12 PDTToolsReplyParameterize source & target table name and also schema details in TPT scriptThe user must have CREATE TABLE access rights in any database in which tables must be created. Error tables and log tables must be created. Error tables are created by the DBS. The restart log ta...
64702 May 2014 @ 11:08 PDTToolsReplyTPT error in loading from an external fileI would imagine all files have an EOF. Every record should also have EOR. (We are fixing the code so that we will treat EOF as EOR on the last record, but that fix is not out yet. Thus, add an EO...
64602 May 2014 @ 10:38 PDTToolsReplyFast Export and MLoad If you are going to be using our load/unload tools for the first time, you should use TPT. It is the suite of load/unload tools going forward. TPT is part of TTU and can be found in the same media...
64501 May 2014 @ 11:30 PDTToolsReplytbuild, failures of EXPORT operator on linuxObviously, a coredump is not good. But I need to know more. On what machine/platform are you running? Can you provide the script? What operators are you using? Does this happen for every job y...
64430 Apr 2014 @ 10:57 PDTToolsReplyTPT export formatted/ timestamp schema mismatchPlease be specific in the issue you are having. Provide the script and the error you are getting.  
64329 Apr 2014 @ 06:25 PDTToolsReplyTPT load to table which contains special characters in name and column namesJust double the single quotes.
64228 Apr 2014 @ 08:37 PDTToolsReplyLoading carriage returns with TPT Load OperatorNo, it did not make it into 15.0, and may not even make it into 15.10.
64124 Apr 2014 @ 01:01 PDTToolsReplyTPT - BUFFERMAX errorI think the clue is here:   Found CheckPoint file: <XXXXXXXX> This is a restart job; it restarts at step Load_data.   Even if/when you think you are running a new job, TPT thi...
64023 Apr 2014 @ 02:24 PDTToolsReplyTPT/Easy Loader delimiterThere is an undocumented feature (undocumented because we may change it to better syntax in the future), where you can provide the text delimiter in hex (I also do not know how much it has been tes...
63923 Apr 2014 @ 11:27 PDTToolsReplyTPT - Assigning default values for columns not present in a file via TPT to load a table1. The SELECT statement on the APPLY-SELECT is not a SELECT statement that is sent to Teradata. It is an internal command that allows TPT to filter out columns from the input record. The SELECT sta...
63816 Apr 2014 @ 12:24 PDTToolsReplyfastload error message: Not enough fields in vartext data record number: 1It is on the same media as the rest of TTU. TPT is a part of TTU.
63716 Apr 2014 @ 09:48 PDTToolsReplyfastload error message: Not enough fields in vartext data record number: 1If you are thinking if starting to use FastLoad and MultiLoad, you should consider using TPT instead (on same media as FastLoad and MultiLoad). We are not adding any features to FastLoad and MultiL...
63609 Apr 2014 @ 10:26 PDTToolsReplyTPTNo. With the FastLoad protocol (TPT LOAD), duplicate rows are never placed in an error table. They are either placed in the target/staging table (NoPI and MULTISET) or discarded altogether. If yo...
63508 Apr 2014 @ 01:38 PDTToolsReplyTPTRows ending up in ERR1 are not due to duplicate rows. They are due to bad data. Running TPT LOAD against a NoPI table will load duplicate rows into that table.  

Pages