#DateForumTypeThreadPost
18421 Sep 2011 @ 02:10 PDTToolsReplyTPT - error TET15111 exporting from Oracle to File Ok, a couple of things. 1. you are not using the DataDirect ODBC drivers and so technically we are not allowed to help you. We only certify the ODBC operator with the ODBC drivers from DataD...
18321 Sep 2011 @ 01:00 PDTToolsReplyCREATION OF ADW USING TPT AND JMS ACCESS MODULES This is a **SAMPLE** TPT script using the JMS access module. It does not contain complete logon credentials. You must fill in the rest. And the information provided herein is only for sa...
18221 Sep 2011 @ 12:36 PDTToolsReplyTPT Crashed That error indicates an inability for the TPT operator to connect to the given TdpId (Teradata database). On the same machine from which you are running TPT, can you connect to the same data...
18121 Sep 2011 @ 12:32 PDTToolsReplydouble pipe delimiter ('||') in Mload script. I looked at the FastLoad manual, and the MultiLoad manual (for 13.00). FastLoad says this: Delimiters can be a multi-character sequence up to a maximum of 10 bytes. Note: Multibyte cha...
18021 Sep 2011 @ 12:24 PDTToolsReplydouble pipe delimiter ('||') in Mload script. I will check with the developers to see why our documentation has not been updated. It is possible the feature was added to a more recent release, and then backported to a prior releases. ...
17921 Sep 2011 @ 11:44 PDTToolsReplyTPT Job sits Eternally in Acquisition Phase It is hard to read the output because the information from the operators is interspersed with each other. However, right now, I would say that the Update operator is waiting in the acquisiti...
17815 Sep 2011 @ 02:30 PDTToolsReplydouble pipe delimiter ('||') in Mload script. Why do you say you are in a dilemma? Have you tried it? Does the MultiLoad manual indicate that multibyte delimiters are supported? (BTW, I believe as of TTU12.0 they are.)  ...
17715 Sep 2011 @ 12:51 PDTToolsReplyhow to select sessions,tenacity,sleep,checkpoint etc for fastload,multiload,tpump utilities As was previously answered, just indicating 100 million rows does not tell us the entire story. How large are the rows? What is your network bandwidth? What is your CPU availablity. ...
17614 Sep 2011 @ 02:21 PDTToolsReplyTPT Oracle JDBC connection I know that you would like to use the Wizard to create the script for you. What version of TPT are you using? I would like for people to move away from the Wizard. It will be de-supporte...
17514 Sep 2011 @ 01:45 PDTToolsReplyskip the header row in the flat file, when importing using FastLoad script The sooner you begin to use TPT the better. The legacy utilities will never go away, but there are many more features in TPT and TPT is the loading tool going forward.  
17414 Sep 2011 @ 01:07 PDTToolsReplyFastload and Dates What is the result? Does FastLoad actually terminate with an error, or are the rows ending up in one of the error tables? (What does "full-stop" mean?)
17314 Sep 2011 @ 01:03 PDTToolsReplydouble pipe delimiter ('||') in Mload script. Did you try it? If it works, it is supported. If it does not work, then it is probably not supported. What version of MultiLoad are you using?    
17214 Sep 2011 @ 01:02 PDTToolsReplyTPT Error TPT19104 VARCHAR field length error in column 1 . Rece ived 771 (max 20) on record 1. Please provide me with the script, and a sample row from the .csv file. Did you define your delimiter character correctly? Looks like the file reader did not detect the delimiter charact...
17108 Sep 2011 @ 01:34 PDTToolsReplyTPT multiple instances using mainframe host (Syntax error). Our mainframe guy suggests this: "The user should reset there  emulater  code-page  to  1047 not  037."   He feels this is an issue with the t...
17008 Sep 2011 @ 12:00 PDTToolsReplyFastLoad Loop Through Multiple Files for Single Table I think you can go one step further. If you use the Easy Loader feature of TPT, you can do this from a command line without a script, using "tdload". The syntax would be someth...
16907 Sep 2011 @ 01:14 PDTToolsReplyMLOAD Error - An invalid statement was found before the .LOGON statement Are you sure you do not have any hidden characters in the file prior to the .logtable command or in between the .logtable and the .logon command?  
16807 Sep 2011 @ 12:11 PDTToolsReplyTPT Oracle JDBC connection We do not certify with any open source ODBC driver. The only ODBC driver with which we certify is DataDirect (now called Progress).  
16707 Sep 2011 @ 11:21 PDTToolsReplyTPT Oracle JDBC connection I believe we will need a bit more information than what you are providing. Are you using the Wizard? Are you using script-based TPT? If script-based, can you send the send? What ...
16601 Sep 2011 @ 11:28 PDTToolsReplyskip the header row in the flat file, when importing using FastLoad script The RECORD command was a part of the FastLoad utility many years prior to the addition of VARTEXT support. (Believe it or not, VARTEXT was not very popular many years ago, all data was in bi...
16531 Aug 2011 @ 11:28 PDTToolsReplyRelease Lock - LOAD Operator - TPT I suppose it depends on the reason for the original failure.
16431 Aug 2011 @ 11:23 PDTToolsReplyTPT error Please provide platform and entire console output. Are you using the Wizard to create the job script? If so, then please try to save that script in text form (Wizard saves it internally ...
16324 Aug 2011 @ 02:10 PDTToolsReplyTeradata Parallel Transporter Wizard 13.10 IssuesTPT only runs in 32-bit mode. We do not have a 64-bit version of TPT. So trying to install a 64-bit version of Teradata Tools will not work. Checking with development, it looks like the Wizard is...
16224 Aug 2011 @ 11:08 PDTToolsReplyTPT multiple instances using mainframe host (Syntax error).Do not want to beat a dead horse here, but whether the script has [1] or not, the job should run. And it runs fine on our MVS system inhouse. Thus, it would be nice to figure out what is wrong wi...
16118 Aug 2011 @ 02:14 PDTToolsReplyTPT multiple instances using mainframe host (Syntax error).I am not sure what Teradata has to do with this. This is just a script parsing issue on the mainframe. We have tried with 13.00.04 inhouse and do not have a problem. Thus, we think there is some ...
16017 Aug 2011 @ 06:20 PDTToolsReplyTPT multiple instances using mainframe host (Syntax error).MultipleReaders is used to invoke a special feature in the DC operator. It will not solve the syntax issue being reported (unless you are using MultipleReader to address a different issue on this ...

Pages