409 | 11 Jan 2013 @ 12:35 PST | Tools | Reply | How to Collect Statistics within a TPT script | You cannot put single quotes within a single quoted string without escaping them. Try doubling each single quote inside the quoted string for the "CALL".
However, if you are using a job ... |
408 | 11 Jan 2013 @ 11:11 PST | Tools | Reply | How to Collect Statistics within a TPT script | What version of TPT are you using?
In general, the DDL operator can send any SQL to Teradata, as long as the request does not result in data being returned to the operator.
I believe we added sup... |
407 | 11 Jan 2013 @ 10:54 PST | Tools | Reply | Loading using Teradata Parallel Transporter Load utility. | As always, you MUST tell me what version of TPT you are using. It is very difficult to know if you are using a version that had a bug that was fixed.
Do not get confused by the "duplicate&quo... |
406 | 10 Jan 2013 @ 11:23 PST | Tools | Reply | How to execute a macro using TPT operator? | Yeah, the operator was originally created to handle just DDL statements, then was expanded, but we cannot change the name.
When in doubt, refer to the documentation for what the operators can and ... |
405 | 10 Jan 2013 @ 11:20 PST | Tools | Reply | TPT Dataconnector Producer for 'Delimited' files to schema's other than VARCHAR? | In 14.0 we added the capability of exporting the data from Teradata and writing out the data in delimited format, and the DC operator will convert the data from binary to character format.
So, you... |
404 | 09 Jan 2013 @ 02:53 PST | Tools | Reply | How to execute a macro using TPT operator? | Yes, the SQL Selector operator is used only for SELECTs (hence its name).
You can try to use the DDL operator, but it depends on what you are trying to do with the macro.
The DDL operator can be ... |
403 | 09 Jan 2013 @ 11:37 PST | Tools | Reply | how to load multiple files in fastload | Please refer to the TPT documentation (same location as the FastLoad documentation).
Also, when you install TPT, we provide sample scripts for a variety of scenarios.
Those scenarios are also des... |
402 | 08 Jan 2013 @ 03:01 PST | Tools | Reply | how to load multiple files in fastload | Please review the FastLoad Reference manual for the correct use of the script language.
(There can only be one DEFINE statement, and that DEFINE statement can only have 1 FILE definition. Each Fas... |
401 | 07 Jan 2013 @ 05:12 PST | Tools | Reply | TPT: How to load file without delimiter exceeding File Data Defintion | You will have to pre-process the file before loading (i.e. write an INMOD or access module). Or convert the file into a delimited file.
|
400 | 04 Jan 2013 @ 04:10 PST | Tools | Reply | Teradata Parallel Transporter : NoPI Tables not supported | We are not adding any additional support to the Wizard.
The best thing to do is to generate a script by hand and use "tbuild".
|
399 | 27 Dec 2012 @ 05:16 PST | Tools | Reply | Problem in writing MULTILOAD script | Well, you answered your own question:
"While having a talk with teradata support they recommended not to use MLOAD on partitioned table s it doesnt support so."
You cannot use MultiLoad... |
398 | 27 Dec 2012 @ 04:50 PST | Tools | Reply | TPT ERROR - General failure (34): 'pmunxRBuf: 'tell' error (Value too large to be stored in data type.)' | Technically, we do not support TPT 12.00 anymore.
Having said that, I have tried looking into which version we began supporting file sizes larger than 2GB.
One thing I see, though, is that you ar... |
397 | 21 Dec 2012 @ 12:33 PST | Tools | Reply | Loading using Teradata Parallel Transporter Load utility. | This forum is not used to teach the client software. In order to assist, you will have to be more specific in your questions. I am not sure what you mean when you say "it" tried writing i... |
396 | 20 Dec 2012 @ 04:38 PST | Tools | Reply | how to load the multiple tables from single file uisng TPT .. | Yes, TPT can do this.
Check out the documentation for the use of the "CASE" syntax.
|
395 | 20 Dec 2012 @ 04:35 PST | Tools | Reply | TPT Error : TPT17134: Terminating due to 1 or more incompatible columns and TruncateData set to FALSE | If you look at the output, you will see one schema defined with "sql_source" like this:
sql_source &nbs... |
394 | 20 Dec 2012 @ 04:26 PST | Tools | Reply | How to get Character String Delimiter with TPT or FastExport | FastExport does not support the writing of delimtied data to files.
TPT can support it if you use the Selector operator for extracting out of Teradata. Using the Data Connector operator as the fil... |
393 | 20 Dec 2012 @ 03:32 PST | Tools | Reply | TPT17122: Error: unable to connect to data source(oracle using TPT script) | Are you using the 32-bit or 64-bit versions of the driver?
TPT is a 32-bit application and you must use the 32-bit versions of the drivers.
|
392 | 20 Dec 2012 @ 03:30 PST | Tools | Reply | TPT: How to load file without delimiter exceeding File Data Defintion | The AcceptExcessColumns feature is currently only supported with the "Delimited" record format. It is not supported with "Text" or any of the binary record formats.
|
391 | 20 Dec 2012 @ 03:27 PST | Tools | Reply | TPT status code 12 during Insert | You will need to get the entire log (the .out file in the "logs" directory) for this job and use tlogview to output all of the detailed information from all of the operators.
|
390 | 20 Dec 2012 @ 02:09 PST | Tools | Reply | TPT script loading issue | Is your target table a SET table, or a MULTISET table? It must be a MULTISET Table in order to load duplicates.
You will need to look at the rest of the log to see where the rows are. They might b... |
389 | 20 Dec 2012 @ 02:04 PST | Tools | Reply | Teradata Parallel Transporter - RDBMS error 3862 | You think that this message is not clear enough?
"The tables in BEGIN LOADING statement must
be different."
Seems pretty clear to me.
|
388 | 20 Dec 2012 @ 01:56 PST | Tools | Reply | Teradata Parallel Transporter Issue | TPT is a 32-bit application.
There is no 64-bit version of TPT. Unless you are using the Wizard, there is no need for any JRE. Thus, just do not use the Wizard (I would rather it not be used anywa... |
387 | 19 Dec 2012 @ 10:02 PST | Tools | Reply | SQL_SELECTOR: TPT15105: Error 13 in finalizing the table schema definition | In general, TPT expects an exact match.
There is no "conversion" for TPT to perform.
For VARCHAR we will allow the actual data to be smaller in size than the schematic. |
386 | 14 Dec 2012 @ 03:29 PST | Tools | Reply | Teradata Parallel Transporter Issue | If you do not allow access to the Indexes table, then you cannot use the "tdload" feature of TPT.
You must create a script and use "tbuild".
When you try to use tdload, the Ea... |
385 | 09 Dec 2012 @ 08:37 PST | Tools | Reply | Teradata PT 12.0 error output schema does not match | TPT is a 32-bit application.
|