#DateForumTypeThreadPost
48427 Aug 2013 @ 10:03 PDTToolsReplyHow do I load VARBINARY data using TPT(Teradata Parallel Transport)Please provide the entire script so we can take a look. It looks like the Teradata database is indicating that you are not specifying BYTE/VARBYTE in the schema properly.
48327 Aug 2013 @ 10:01 PDTToolsReplyFLOAD: How to load different flat files to a single table using fastload without merging the flat filesThe FastLoad Reference Manual has all of the information you need to learn how to load multiple files into a single Teradata table.  
48221 Aug 2013 @ 10:50 PDTToolsReplyTeradata Fastload has stopped workingIncrease the size of your VARCHAR fields. The first field was defined as VARCHAR(15) but has 16 bytes. (There may be a coredump issue we are unaware of?)
48114 Aug 2013 @ 07:18 PDTToolsReplyRejected Rows in TeradataThese are 2 different scenarios and cannot be lumped together. The ErrorLimit feature is an operator-specific (not job-specific) feature and is currently controlled by the consumer operator (i.e. ...
48014 Aug 2013 @ 11:31 PDTToolsReplyRejected Rows in TeradataIt depends on what you mean by "rejected" rows. The RowErrFileName attribute only works for rows that can be rejected by the DataConnector operator. Not the rows rejected by Teradata. ...
47914 Aug 2013 @ 11:08 PDTToolsReplyTPT time zoneI am not sure where you see that syntax being supported in the FastLoad script syntax. It is not. It is not possible to set a session timezone in any of our load/unload product scripts.
47808 Aug 2013 @ 10:10 PDTToolsReplyTPT - Instances Vs SessionsIf, by "task", you mean "load slot", then it is one load slot per operator. Not per instance.
47707 Aug 2013 @ 10:53 PDTToolsReplyTPT Dataconnector Producer for 'Delimited' files to schema's other than VARCHAR?With 13.10, if you want to export data and have it written out in delimited format, you must use the Selector operator (with ReportMode set to yes) and the schema must be all VARCHAR (with the size...
47606 Aug 2013 @ 03:35 PDTToolsReplyTeradata PT 12.0 error output schema does not matchWhat is the data type of COMPLIANCE? In the future, try to provide more information (like a copy of the script?).  
47506 Aug 2013 @ 10:21 PDTToolsReplySQL_SELECTOR: TPT15105: Error 13 in finalizing the table schema definitionIt is not so much the FORMAT, as whether the data is being exported as an integer value, or a character string. If you are telling the database to export the data in ANSI date mode, then your schem...
47405 Aug 2013 @ 12:41 PDTToolsReply64-bit TPT Tools versus 32-bit TPT ToolsProbably not. We have not seen any appreciable performance improvements with 64-bit TPT (in development).
47305 Aug 2013 @ 11:29 PDTToolsReply64-bit TPT Tools versus 32-bit TPT ToolsTPT v14.00 only runs in 32-bit mode.   You might see 64-bit versions of the Load, Update, Export and Stream operators because they are used by TPTAPI.  
47205 Aug 2013 @ 11:28 PDTToolsReplyTPT - Instances Vs SessionsOk, will try to answer the questions in order from the 2 posts:   The Stream operator is different from the Load and Update. Each instance of the Stream is sending their own requests. With t...
47131 Jul 2013 @ 01:13 PDTToolsReplyUnable to use twbcmd to terminate a job is a FileReader is using Vigil to wait on new filesWe are aware of this issue, but not much can be done about it right now. When you use Vigil, you are effectively telling the operating system to "sleep" for a particular duration of time...
47031 Jul 2013 @ 11:57 PDTToolsReplyTPT - Instances Vs SessionsPerformance is always dependent upon where your normal bottleneck would be. If the bottleneck is on the file I/O, then TPT may not be able to help much. If the bottleneck is on the network side, ...
46931 Jul 2013 @ 11:47 PDTToolsReplyTeradata TPT ScriptI would think if you have an error of this nature, and you would like assistance, you would provide a little more information than what you have provided. What version of TPT are you using? Provi...
46822 Jul 2013 @ 08:43 PDTToolsReplyZip/GZip Support in TTU 14?TPT only supports a single file that has been ZIP-ed.  
46717 Jul 2013 @ 08:02 PDTToolsReplyEnd of CSV File / FastloadThat is the way FastLoad works. The reading of the file is expecting each record in the file to adhere to the DEFINE list of columns. There is no workaround in FastLoad.  
46615 Jul 2013 @ 02:52 PDTToolsReplyLoading a teradata table using multiple files sample scriptThe User Guide will also have the information you need.  
46515 Jul 2013 @ 02:51 PDTToolsReplyTPT output from ODBC includes Indicator Bytes?Data is sent to Teradata in indicator mode by all of our operators, and it is not something the user can control. The only option is for the user to tell us whether the incoming data is in indicat...
46411 Jul 2013 @ 10:13 PDTToolsReplyParameterize source & target table name and also schema details in TPT scriptPlease refer to the TPT documentation for the full explanation of how to use Job Variables. The User Guide should provide the needed information.  
46310 Jul 2013 @ 12:36 PDTToolsReplyTPT and Unix/Linux Environment VariablesNot sure why the -u command line option cannot be used for this approach. That is what it is for. Or a different job variable file for each job. However, the OS environment variable solution is o...
46210 Jul 2013 @ 12:33 PDTToolsReplyFast load ErrorIsn't the abend occurring because of the Error Limit being set to some value? The ErrorLimit command should be removed so that the job does not terminate during the acquisition phase after ...
46110 Jul 2013 @ 12:30 PDTToolsReplyUsing FastLoad for Volatile TableThe table creation did not fail because the CREATE TABLE occurred prior to the BEGIN LOADING statement. The BEGIN LOADING statement is the statement that initiates the FastLoad protocol on Teradat...
46010 Jul 2013 @ 12:16 PDTToolsReplyParameterize source & target table name and also schema details in TPT scriptWhich version of TPT are you using? Please refer to the TPT documentation for the use of Job Variables. Everything in a TPT script is substitutable. In fact, we do not want you to hardcode anyth...

Pages