#DateForumTypeThreadPost
33412 Sep 2012 @ 02:53 PDTToolsReplyusage of check point in fastload FastLoad can load duplicate rows into NoPI tables. Normally, the DBS throws away duplicates during the sort (in the Application Phase). NoPI tables are always MULTISET tables, but since ...
33312 Sep 2012 @ 11:34 PDTToolsReplyTPT script for Sybase If ODBC can be used to extract data from Sybase, then you can use the TPT ODBC operator. Please consult the TPT documentation (most likely, the User Guide) for more information and script sa...
33229 Aug 2012 @ 09:56 PDTToolsReplyTeradata Wallet Have you tried putting the text "$tdwallet(put_item_name_here)" as the value of the UserPassword attribute (or on the command line with the -u option, or in the job variable file)?
33124 Aug 2012 @ 05:24 PDTToolsReplyTPT script: error while executing TPT script "tbuild -v <script>" is not valid syntax. If you are providing the script, use the -f option. If you would like further help on this you are going to have to provide the ...
33023 Aug 2012 @ 12:50 PDTToolsReplyTPT API : Setting DSNName attribute through TPT API script for a source database The TPTAPI interface only connects to Teradata. It does not connect to Oracle. If you would like to move data from Oracle to Teradata, then use the script-based TPT, and use our ODBC ope...
32923 Aug 2012 @ 12:48 PDTToolsReplyLoad text of variable length from MQ via TPT into Teradata The data coming through the message queue must be in "load-ready" format. This means the data must adhere to one of our supported record format definitions. If you want the data to...
32822 Aug 2012 @ 02:32 PDTToolsReplyLoad text of variable length from MQ via TPT into Teradata Please give an example of the data you would like to load. And I can then help you code your script. You can load any type of data as long as the data on the queue matches the schema (an...
32716 Aug 2012 @ 12:08 PDTToolsReplyTPT export issue (One of the FastExport session has been logged off) Contact the GSC and work with them on this. You also upgrade TPT to the latest patch level as a first solution.  
32616 Aug 2012 @ 12:05 PDTToolsReplyInsert select in Mload I agree with Dieter. Ask your lead. MultiLoad is not intended for issuing insert-select statements. You should be using a tool like BTEQ for that type of operation. The one area ...
32516 Aug 2012 @ 11:29 PDTToolsReplySQL_SELECTOR: TPT15105: Error 13 in finalizing the table schema definition Normally, we enforce that the schema definition must match the data coming from the database (exactly). However, we did make a change to TPT in 13.10 (in efix #3) to allow the schema to have...
32415 Aug 2012 @ 07:28 PDTToolsReplyInsert select in Mload I have read all of the posts here and I will repeat: you are trying to use MultiLoad in a way that is not proper. MultiLoad is a load tool to provide the capability of performing insert, upd...
32315 Aug 2012 @ 04:36 PDTToolsReplyInsert select in Mload General statement: SQL statements cannot start with a period ("."). So, the CREATE ERROR TABLE statement should not have the period.   However, you are trying to u...
32215 Aug 2012 @ 11:15 PDTToolsReplyTPT - LOAD_OPERATOR - Issue Please provide the schema and a sample of your input data.  
32109 Aug 2012 @ 02:27 PDTToolsReplyTPT API : Setting DSNName attribute through TPT API script for a source database TPTAPI does not use a script, and so referring to TPTAPI in this context is not correct. TPTAPI is an "API" interface in which you write a C++ program to have direct control over t...
32009 Aug 2012 @ 12:31 PDTToolsReplyfastload issue with inmod path If you have access to TPT, then you should use that. We provide a seamless way of moving data from Oracle to Teradata without the need to write custom INMODs. If you write your own INMOD you...
31908 Aug 2012 @ 03:07 PDTToolsReplyProblem with TPT 12 "TPT" i used to refer to the script-based tool. "TPTAPI" is the API-version of TPT. TD_TRACE_OUTPUT is a method for generating debug information to help diagnose a pa...
31830 Jul 2012 @ 10:05 PDTToolsReplynew line character You never mentioned what record format you WANT to use. You only commented on the record delimiter. Are you trying to use "delimited" format? (Even if you are, there are st...
31730 Jul 2012 @ 06:45 PDTToolsReplynew line character As to the request for a change to support alternative EOR, there are no plans to support that, even if requested.  
31630 Jul 2012 @ 06:43 PDTToolsReplynew line character What do you mean, it is not variable length? Sure it is. It uses the schema to read the data, field-by-field. In other words, if your schema had INTEGER, CHAR(10), VARCHAR(100), the ...
31530 Jul 2012 @ 04:22 PDTToolsReplynew line character No. Those are defined record format definitions. However, you can try and use the "unformatted" record format type where our tools will just read in the data according to the schem...
31427 Jul 2012 @ 09:43 PDTToolsReplyTPT : tlogview Parameters and options I think when you wrote this:     I have a doubt using tbuild -j jobid -w option, you meant this:     I have a doubt using tlogview -j jobid -w option, ...
31318 Jul 2012 @ 11:18 PDTToolsReplyCan we use SELECT in MLOAD. You cannot issue a SELECT in the MultiLoad script. However, if you want to exit with a different exit code based on whether there are rows in an error table, MultiLoad has system variables t...
31216 Jul 2012 @ 06:23 PDTToolsReplyIssues in fast export That looks like a BTEQ script, not a FastExport script.
31116 Jul 2012 @ 02:43 PDTToolsReplyThis MultiLoad import task cannot proceed: an unexpected MultiLoad phase, data acquisition, was reported by the RDBMS. It would be helpful to see the entire MultiLoad output, but without that I can answer that the issue has to do with a synchronization problem between MultiLoad and the database. They both ha...
31016 Jul 2012 @ 01:18 PDTToolsReplyTPT: system variables with result count The system variable enhancement has been on our list of features to implement for a long time. But, like everything else, features are prioritized and this one never seems to make it high enough...

Pages