184 | 21 Sep 2011 @ 02:10 PDT | Tools | Reply | TPT - 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... |
183 | 21 Sep 2011 @ 01:00 PDT | Tools | Reply | CREATION 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... |
182 | 21 Sep 2011 @ 12:36 PDT | Tools | Reply | TPT 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... |
181 | 21 Sep 2011 @ 12:32 PDT | Tools | Reply | double 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... |
180 | 21 Sep 2011 @ 12:24 PDT | Tools | Reply | double 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.
... |
179 | 21 Sep 2011 @ 11:44 PDT | Tools | Reply | TPT 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... |
178 | 15 Sep 2011 @ 02:30 PDT | Tools | Reply | double 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.)
 ... |
177 | 15 Sep 2011 @ 12:51 PDT | Tools | Reply | how 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.
... |
176 | 14 Sep 2011 @ 02:21 PDT | Tools | Reply | TPT 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... |
175 | 14 Sep 2011 @ 01:45 PDT | Tools | Reply | skip 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.
|
174 | 14 Sep 2011 @ 01:07 PDT | Tools | Reply | Fastload 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?)
|
173 | 14 Sep 2011 @ 01:03 PDT | Tools | Reply | double 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?
|
172 | 14 Sep 2011 @ 01:02 PDT | Tools | Reply | TPT 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... |
171 | 08 Sep 2011 @ 01:34 PDT | Tools | Reply | TPT 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... |
170 | 08 Sep 2011 @ 12:00 PDT | Tools | Reply | FastLoad 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... |
169 | 07 Sep 2011 @ 01:14 PDT | Tools | Reply | MLOAD 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?
|
168 | 07 Sep 2011 @ 12:11 PDT | Tools | Reply | TPT 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).
|
167 | 07 Sep 2011 @ 11:21 PDT | Tools | Reply | TPT 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 ... |
166 | 01 Sep 2011 @ 11:28 PDT | Tools | Reply | skip 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... |
165 | 31 Aug 2011 @ 11:28 PDT | Tools | Reply | Release Lock - LOAD Operator - TPT |
I suppose it depends on the reason for the original failure.
|
164 | 31 Aug 2011 @ 11:23 PDT | Tools | Reply | TPT 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 ... |
163 | 24 Aug 2011 @ 02:10 PDT | Tools | Reply | Teradata Parallel Transporter Wizard 13.10 Issues | TPT 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... |
162 | 24 Aug 2011 @ 11:08 PDT | Tools | Reply | TPT 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... |
161 | 18 Aug 2011 @ 02:14 PDT | Tools | Reply | TPT 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 ... |
160 | 17 Aug 2011 @ 06:20 PDT | Tools | Reply | TPT 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 ... |