#DateForumTypeThreadPost
43414 Mar 2013 @ 05:31 PDTToolsReplyMLOAD QuestionSequential.
43312 Mar 2013 @ 10:14 PDTToolsReplyMultiLoad instead of FastLoadThe Stream operator does NOT use ODBC. The Update operator is part of TPT, so the answer to your first question is yes.  
43211 Mar 2013 @ 10:39 PDTToolsReplyUtilities to export data from Teradata to Oracle?Our load/unload products are created to load data into Teradata.
43111 Mar 2013 @ 10:38 PDTToolsReplyTeradata export to DB2 using TPTOur load/unload products are created to load data into Teradata. TPT only loads into Teradata.  
43011 Mar 2013 @ 10:37 PDTToolsReplyError when loading table using OLE LoadWhy would you use OLELoad to load data from a flat file into Teradata when we have our standard load/unload products that are much faster?  
42908 Mar 2013 @ 03:35 PSTToolsReplyTPT return code 12 during INSERT@gpolanch: it is not intuitive, but the WorkingDatabase dictates to which database context we switch after we connect. However, due to a backwards compatibility issue (we have to act the way MultiL...
42827 Feb 2013 @ 07:02 PSTToolsReplyTPT export formatted/ timestamp schema mismatchWhat version of 13.10 are you using? The issue you are having was fixed in 13.10.00.07.  
42727 Feb 2013 @ 04:51 PSTToolsReplyTeradata TPT Scriptrku2013: please post the entire script and entire schema file. (you probably should have the entire "DEFINE SCHEMA" syntax in the external schema file)
42627 Feb 2013 @ 04:49 PSTToolsReplyTeradata TPT ScriptPetlee: try DEFINE SCHEMA S_SCHEMA DELIMITED FROM TABLE 'DBC.DBQLogTBL';
42513 Feb 2013 @ 11:55 PSTToolsReplyUsing TPT to move Tables across DatabasesThe TPT User Guide will describe how to do that. Also, there are sample scripts in the "samples" directory under the root install directory for TPT that should be able to provide the inf...
42407 Feb 2013 @ 07:15 PSTToolsReplyLoading using Teradata Parallel Transporter Load utility.The SELECT statement is not a Teradata SELECT statement. It is a TPT SELECT. Thus, not all SQL is supported (please check the documentation). We do not support the TRIM function in TPT. Any &quo...
42307 Feb 2013 @ 07:10 PSTToolsReplyHow to get Character String Delimiter with TPT or FastExportA TPT license does not cost any extra if you have a FastLoad/FastExport/MultiLoad license. TPT is the load/unload tool going forward and thus it is the tool that will receive the new features and ...
42230 Jan 2013 @ 06:36 PSTToolsReplyTPT error in loading from an external fileIs there an end-of-record marker after the last data item in the last record?  
42130 Jan 2013 @ 05:04 PSTToolsReplyTPT OS COMMAND OPERATOR ISSUE"cd" will not work. There is no context when sending operating system commands. The operator just issues the commands, but there is no shell from which these commands are being run or ex...
42029 Jan 2013 @ 05:13 PSTToolsReplytdload a table with auto increment primary keyPlease re-run the job with the command line option:     --SourceTraceLevel 'Y' and then send the log to steven.feinholz@teradata.com. The log will be in the "logs&quo...
41929 Jan 2013 @ 11:46 PSTToolsReplyTPT 14.00 DEFINE SCHEMA / DELIMITED optionPlease refer to the documentation for the proper syntax. In this case it would be: DEFINE SCHEMA sandbox DELIMITED 'sandbox.tablename';
41822 Jan 2013 @ 10:11 PSTToolsReplyTPT script to move data from table to fileYes, you can export data from a view (it might depend on which operator you use for that, you will have to check the documentation). Yes, you can execute TPT by calling it from a shell script. Yo...
41722 Jan 2013 @ 10:01 PSTToolsReplyTeradata TPT ScriptWell, you could do this: DEFINE JOB <name> (       %INCLUDE '<schema file name>';       . . . . ); However, the DEFINE SC...
41621 Jan 2013 @ 03:33 PSTToolsReplyTeradata TPT ScriptYes, the table name must have single-quotes in the job var file; the variable substitution will carry forward the single-quotes, which is necessary. As for putting a schema in a job var file, I do...
41521 Jan 2013 @ 03:29 PSTToolsReplyTPT script to move data from table to file1. No, not supported yet. 2. No. 3. No, not available yet. 4. Yes, it is called the OS Command Operator. Please refer to the TPT documentation for #4.  
41417 Jan 2013 @ 05:57 PSTToolsReplyTeradata TPT ScriptYou are getting a syntax error because the variable substitution is substituting everything, including the single quotes. And those single quotes are causing the syntax errors. This is not really ...
41315 Jan 2013 @ 11:07 PSTToolsReplyHow to get Character String Delimiter with TPT or FastExportYes, you can run 14.0 TPT against TD 13.10. Field information cannot be passed to an OUTMOD. An OUTMOD must be written customized for that particular job (it must know the data layout).
41215 Jan 2013 @ 11:05 PSTToolsReplyHow to Collect Statistics within a TPT scriptStored Procedure support went into TPT in 14.0. I do not know of any other option for TPT to collect stats.
41114 Jan 2013 @ 04:04 PSTToolsReplyHow to get Character String Delimiter with TPT or FastExportIn TPT 14.0 we added "quoted delimited data support" which will allow for character strings to be enclosed in quotes. The opening and closing quote marks can be provided by the user, and ...
41014 Jan 2013 @ 11:35 PSTToolsReplyHow to execute a macro using TPT operator?TPT does not currently support IF-THEN-ELSE conditional statements.

Pages