#DateForumTypeThreadPost
40911 Jan 2013 @ 12:35 PSTToolsReplyHow to Collect Statistics within a TPT scriptYou 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 ...
40811 Jan 2013 @ 11:11 PSTToolsReplyHow to Collect Statistics within a TPT scriptWhat 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...
40711 Jan 2013 @ 10:54 PSTToolsReplyLoading 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...
40610 Jan 2013 @ 11:23 PSTToolsReplyHow 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 ...
40510 Jan 2013 @ 11:20 PSTToolsReplyTPT 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...
40409 Jan 2013 @ 02:53 PSTToolsReplyHow 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 ...
40309 Jan 2013 @ 11:37 PSTToolsReplyhow to load multiple files in fastloadPlease 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...
40208 Jan 2013 @ 03:01 PSTToolsReplyhow to load multiple files in fastloadPlease 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...
40107 Jan 2013 @ 05:12 PSTToolsReplyTPT: How to load file without delimiter exceeding File Data DefintionYou 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.
40004 Jan 2013 @ 04:10 PSTToolsReplyTeradata Parallel Transporter : NoPI Tables not supportedWe are not adding any additional support to the Wizard. The best thing to do is to generate a script by hand and use "tbuild".
39927 Dec 2012 @ 05:16 PSTToolsReplyProblem in writing MULTILOAD scriptWell, 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...
39827 Dec 2012 @ 04:50 PSTToolsReplyTPT 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...
39721 Dec 2012 @ 12:33 PSTToolsReplyLoading 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...
39620 Dec 2012 @ 04:38 PSTToolsReplyhow 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.  
39520 Dec 2012 @ 04:35 PSTToolsReplyTPT Error : TPT17134: Terminating due to 1 or more incompatible columns and TruncateData set to FALSEIf you look at the output, you will see one schema defined with "sql_source" like this:  sql_source             &nbs...
39420 Dec 2012 @ 04:26 PSTToolsReplyHow to get Character String Delimiter with TPT or FastExportFastExport 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...
39320 Dec 2012 @ 03:32 PSTToolsReplyTPT17122: 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.  
39220 Dec 2012 @ 03:30 PSTToolsReplyTPT: How to load file without delimiter exceeding File Data DefintionThe AcceptExcessColumns feature is currently only supported with the "Delimited" record format. It is not supported with "Text" or any of the binary record formats.  
39120 Dec 2012 @ 03:27 PSTToolsReplyTPT status code 12 during InsertYou 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.
39020 Dec 2012 @ 02:09 PSTToolsReplyTPT script loading issueIs 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...
38920 Dec 2012 @ 02:04 PSTToolsReplyTeradata Parallel Transporter - RDBMS error 3862You think that this message is not clear enough? "The tables in BEGIN LOADING statement must be different." Seems pretty clear to me.  
38820 Dec 2012 @ 01:56 PSTToolsReplyTeradata Parallel Transporter IssueTPT 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...
38719 Dec 2012 @ 10:02 PSTToolsReplySQL_SELECTOR: TPT15105: Error 13 in finalizing the table schema definitionIn 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.
38614 Dec 2012 @ 03:29 PSTToolsReplyTeradata Parallel Transporter IssueIf 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...
38509 Dec 2012 @ 08:37 PSTToolsReplyTeradata PT 12.0 error output schema does not matchTPT is a 32-bit application.

Pages