#DateForumTypeThreadPost
28417 May 2012 @ 01:31 PDTToolsReplyfastload windows 64-bit? There are no plans (ever) to create a native 64-bit version of FastLoad on Windows.
28311 May 2012 @ 05:21 PDTToolsReplyTPT return code 12 during INSERT Try naming the log table with the database name qualifier. When you provide a value for the WorkingDatabase, we issue the SQL DATABASE request under the covers. But that then changes the con...
28208 May 2012 @ 07:31 PDTToolsReplyTPT variables in script itself (Providing a default value that could then be overridden) Yes, you can do this. You must create a job variable. You will assign a value to the job variable on the command line (or in the job variable file). You then need to restructure your DML sta...
28108 May 2012 @ 07:27 PDTToolsReplyTPT return code 12 during INSERT This might be a case where you switched databases but did not clean up between the first job run and the subsequent one. Thus, TPT thinks the job is a restart, but the error you are getting ...
28008 May 2012 @ 07:21 PDTToolsReplyFastload Import very slow This is highly unsual, even with a checkpoint every 500 rows, and only 2 sessions (I mean, it would be slow with only 2 sessions but not that slow). Have you tried removing the checkpoint? ...
27908 May 2012 @ 06:13 PDTToolsReplyProblem using RowErrFileName First, how many bytes are you providing in that first record? Next, at a minimum you need to upgrade to the latest patch for TPT 13.00 and all of its packages. We have many bug fixes since p...
27807 May 2012 @ 02:21 PDTToolsReplyFastload error-Kindly Help!! If you do not provide a session number, then FastLoad will connect one session per available AMP on the system.
27707 May 2012 @ 01:46 PDTToolsReplyhow does fastexport multiple sessions works? If you are using DataStage then you are most likely using TPTAPI. The TPTAPI operator to which you are referring is the Export operator, and that operator behaves like FastExport. The operat...
27627 Apr 2012 @ 04:22 PDTToolsReplyTPT Dataconnector Producer for 'Delimited' files to schema's other than VARCHAR? Documentation is incorrect. I questioned engineering about it; I am not sure why or how they could have an example script that does not work. I have been told that we made a lot of corre...
27527 Apr 2012 @ 04:18 PDTToolsReplyFastload DateTime, Timestamp Carlos, I am not sure to what you are disagreeing. With the data presented as VARCHAR (delimited data is read in as a series of VARCHAR fields), FastLoad would create a USING clause on the I...
27427 Apr 2012 @ 04:15 PDTToolsReplyFastload DateTime, Timestamp That NULLIF example will not work. The NULLIF feature says "NULL the column if the value of the field is equal to the value in the NULLIF clause". The NULLIF feature cannot do ...
27326 Apr 2012 @ 09:16 PDTToolsReplyTELAPI Initialize error on Linux64 TPT API 13.10 "[CLI2: BUFOVFLOW(308): Parcel data too large for receiving buffer.]" We are investigating and I will update here when we have a resolution.
27223 Apr 2012 @ 10:01 PDTToolsReplyTELAPI Initialize error on Linux64 TPT API 13.10 "[CLI2: BUFOVFLOW(308): Parcel data too large for receiving buffer.]" When you install CLI you can install both 32-bit and 64-bit. I believe they reside in different directories. You would have to check the CLI documentation about how to enable one over th...
27123 Apr 2012 @ 09:31 PDTToolsReplyTPT Dataconnector Producer for 'Delimited' files to schema's other than VARCHAR? The answer is quite simple. The Schema object defines the format of the data as it is being provided to the DataConnector operator. It has nothing to do with the data types of columns in the...
27019 Apr 2012 @ 06:00 PDTToolsReplyTELAPI Initialize error on Linux64 TPT API 13.10 "[CLI2: BUFOVFLOW(308): Parcel data too large for receiving buffer.]" If you have switched to 64-bit TPTAPI, are you sure you are using 64-bit CLI?  
26916 Apr 2012 @ 10:38 PDTToolsReplyPassing date parameter (current month) to tbuild from command line There must be some other syntax problem with the script. Doubling the single-quote was just to get you to supply the correct value to the WHERE clause (the string '1' instead of the nume...
26813 Apr 2012 @ 12:53 PDTToolsReplyPassing date parameter (current month) to tbuild from command line Ok, a couple of things. First, I mistyped. The concatenation *is* || and not |. Second, you cannot put VARCHAR Cd = @Cd in the attribute list. That will not do anything. The operator...
26712 Apr 2012 @ 11:41 PDTToolsReplyPassing date parameter (current month) to tbuild from command line If your job variable is "curr_month" then the command line would be something like this: tbuild -f text.txt -u "curr_month=201204" Please read the documentation on th...
26611 Apr 2012 @ 07:05 PDTToolsReplyPassing date parameter (current month) to tbuild from command line TPT itself cannot send data to Oracle, so it is not clear to me from your post how you are getting the data from Teradata to Oracle. However, as far as passing information into a script, you...
26510 Apr 2012 @ 05:51 PDTToolsReplyTeradataParallelTransport API Table Schema Mismatch Error There is a specific method for creating the buffer. You cannot just place rows contiguously into a buffer. Please consult the TPTAPI documentation for creating the buffer.  
26409 Apr 2012 @ 11:07 PDTToolsReplyTeradataParallelTransport API Table Schema Mismatch Error Well, we definitely need more information than this. Are you saying that when you use putrow() instead of putbuffer(), you do not get this problem? Are you sure you are building the buff...
26304 Apr 2012 @ 01:42 PDTToolsReplyskip the header row in the flat file, when importing using FastLoad script Yes, you *should* be able to use 13.10 client against V2R6.2.
26204 Apr 2012 @ 11:54 PDTToolsReplyTPT Load Operator error table being loaded? The names of the tables will be in the script you used. If you used tdload, then the names of the tables correspond to the name of the target table, except with a _ET or _UV suffix. The ...
26104 Apr 2012 @ 11:46 PDTToolsReplyskip the header row in the flat file, when importing using FastLoad script Look in the Reference manual, in the chapter on the DataConnector operator (the file reader operator) at the SkipRows attribute.
26003 Apr 2012 @ 12:58 PDTToolsReplyskip the header row in the flat file, when importing using FastLoad script Please read the TPT documentation at www.info.teradata.com. All of the proper attributes and their uses and values are provided. Do not assume that the same command name from FastLoad is...

Pages