#DateForumTypeThreadPost
44606 May 2013 @ 10:57 PDTToolsReplybteq export and import for _ET dataparcelThe data in the varbyte does not have the delimiter. We do not send "delimited" data to Teradata. We process the delimited data and send the row to Teradata as a series of VARCHAR fields....
44506 May 2013 @ 03:47 PDTToolsReplybteq export and import for _ET dataparcelEven though the data is in a binary format, the only reason why it is stored in a VARBYTE is so that the endianness character set encoding is preserved. The data itself is in the exact format that ...
44406 May 2013 @ 10:39 PDTToolsReplybteq export and import for _ET dataparcelThe tool is still in development. There is no release date yet.  
44323 Apr 2013 @ 02:15 PDTToolsReplyTPT19350 I/O error on fileYou should read the documentation to understand the various formats that we support, and then when creating that file, make sure to create it with one of the supported formats. Our own tools (obvi...
44222 Apr 2013 @ 02:39 PDTToolsReplyTPT19350 I/O error on fileYou have specified a record format of "formatted". Are you sure your data file adheres to the required format?  
44117 Apr 2013 @ 12:35 PDTToolsReplyTPT + Named pipesTPT requires the file names in the -f option be a physical disk file.
44008 Apr 2013 @ 06:26 PDTToolsReplyStrange Errorcode in TPT error tableDid you really obtain that information from executing a SELECT statement against the error table? Normally, the content of the "DataParcel" field is not legible.  
43908 Apr 2013 @ 01:21 PDTToolsReplyUsing name of Flat File in TPT Load Right now, the METADATA feature is only supported with a record format of DELIMITED.
43821 Mar 2013 @ 11:59 PDTToolsReplyImproving Loading Mechanism using FastloadYes. TPT supports it. Please refer to the TPT documentation (user guide).
43718 Mar 2013 @ 10:42 PDTToolsReplySQL_SELECTOR: TPT15105: Error 13 in finalizing the table schema definitionWell, without seeing the entire script, what you have shown me is a Selector operator retrieving 2 DECIMAL columns and a VARCHAR. Therefore, your schema must match.  
43618 Mar 2013 @ 06:01 PDTToolsReplySQL_SELECTOR: TPT15105: Error 13 in finalizing the table schema definition@ericsun2: the schema must match the data. Thus the Selector is retrieving 2 DECIMALs and a VARCHAR. Your schema does not match that. And yes, if you are using a client session character set of UT...
43518 Mar 2013 @ 11:20 PDTToolsReplyTpump Error, Invalid session modeThe user cannot change the session mode. TPump will always run in Teradata mode.
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?  

Pages