#DateForumTypeThreadPost
3410 Sep 2009 @ 02:31 PDTToolsReplyVerify Version loadedAnother option is to find out what the package commands are for your operatingsystem. One of those commands will result in listing the installed packages on yoursystem.For example, on MPRAS, I beli...
3303 Sep 2009 @ 10:26 PDTToolsReplyHow to Convert VARCHAR(30) to a DATE in FastloadIf the data is coming in in delimited format, you cannot change the fields of the DEFINE statement.They must be VARCHAR.I am not sure why that is important to the customer.The DEFINE statement desc...
3203 Sep 2009 @ 06:37 PDTToolsReplyHow to Convert VARCHAR(30) to a DATE in FastloadI guess I am not clear on what you are asking.When processing delimited data, FastLoad requires that the DEFINE statement be comprised of VARCHAR fields.FastLoad will read in the fields, and send t...
3125 Aug 2009 @ 09:07 PDTToolsReplyHow to loading the large object into the BLOB column?Teradata Parallel Transporter can also load LOBs. It cannot use the FastLoad and MultiLoad protocols, it has a SQL Inserter operator (similar to BTEQ import), but it does provide some parallelism.
3012 Aug 2009 @ 02:22 PDTToolsReplyHow to fetch records using CLIv2It is best to post this to the Teradata Developer Exchange as that is the forum going forward; this forum will be discontinued, and may therefore not be monitored by very many people.Having said al...
2912 Aug 2009 @ 02:10 PDTToolsReplyNumber of SessionsIt would be best if you posted this to the Teradata Developer Exchange as this forum will be discontinued.Please let me know what you mean by "teach" the utilities to use multiple sessions.FastLoad...
2812 Aug 2009 @ 02:07 PDTToolsReplyError Accessing Fast Export UtilityLeave that field blank.
2704 Aug 2009 @ 10:37 PDTToolsReplyFastload not handling VARCHAR field in Linux?One more thing to provide to us please. I would like to see the entire output of the FastLoad job. I want to see the column/byte layout of all columns.
2604 Aug 2009 @ 10:36 PDTToolsReplyFastload not handling VARCHAR field in Linux?First of all, let me add that the wilcard INSERT syntax does not always work on tables that have Unicode columns. I am not sure if this is documented, but we have seen problems in this area. Ha...
2531 Jul 2009 @ 03:32 PDTToolsReplyFastload not handling VARCHAR field in Linux?The partial dump above shows a 2-byte length of 14 (16 octal), but I am not sure if that snippet is the record, or just the field. So, we need more info. It would probably help as well to see...
2431 Jul 2009 @ 10:36 PDTToolsReplyFastload not handling VARCHAR field in Linux?Can you FastExport a couple of rows and send me the data (for the one that consistently fails), and a copy of the table schema for both tables?
2330 Jul 2009 @ 01:47 PDTToolsReplyFlat files to Teradata tablesTeradata has a lot of load/unload products that load data from flat files into Teradata.FastLoad, MultiLoad, BTEQ, Teradata Parallel Transporter just to name a few.
2230 Jul 2009 @ 01:46 PDTToolsReplyDB2 database to teradataTeradata Parallel Transporter has an ODBC operator that will enable the user to move data fromDB2 to Teradata using ODBC.
2130 Jul 2009 @ 11:06 PDTToolsReplyFastload not handling VARCHAR field in Linux?Where is the data coming from? In what format is the data? If in FastLoad format, then the record must contain the proper format (2-byte row length 'n', followed by 'n' bytes of data, followed by...
2029 Jul 2009 @ 02:50 PDTToolsReplyTPT error code 29Please send me your script. If you could generat the output from the job and send me that as well, that would be helpful. From the command line: tlogview -j -f "*" -g and redirect the...
1924 Jul 2009 @ 08:30 PDTToolsReplyImproving Loading Mechanism using FastloadDepending on where the bottleneck is, TPT could still product faster results (unless you are totally I/O bound or CPU bound).TPT supports the MultiLoad protocol as well.If you have the CPU and I/O ...
1824 Jul 2009 @ 08:23 PDTToolsReplyTD ParellelTransporterYou will find that our load/unload products are used to load data into Teradata, not into non-Teradata databases.Teradata Parallel Transporter can load data FROM Oracle INTO Teradata, but not the o...
1701 Jul 2009 @ 10:10 PDTToolsReplyFastLoad Error -incorrect number of bytes returnedLooks like you are using delimited data.Any reason why you are not using SET RECORD VARTEXT?
1601 Jul 2009 @ 10:09 PDTToolsReplyTPT errorAre you using the Wizard?Can you cut and paste and the script to a text file and run from the command line?One thing I see in your script is the use of Job Variables.I do not think the Wizard can h...
1510 Jun 2009 @ 01:12 PDTToolsReplyWhy i get this error when using generic named pipe for Warehous ebuilder (now TPT)If you are running the script-based TPT, then you need to install script-based TPT.It looks as if you are running TPT and supplying a script, but you never installedthe Load operator and the DataCo...
1410 Jun 2009 @ 01:09 PDTToolsReplyProblem with TPT 12You indicated that you are using TPT12.0, but it sounds as if you arereally using TPTAPI (by your use of TD_xxxxxx attribute names).The Export operator does not support a target table attribute. Ho...
1310 Jun 2009 @ 01:06 PDTToolsReplyTD Parallel Transporter DDL OperatorWhich version of the DDL operator are you using? The use of the DDL operatorwas severely restricted, but we opened it up in TPT13.0 and then backshippedthe support to TPT12.0 (with a patch).If you ...
1203 Jun 2009 @ 08:01 PDTToolsReplyImproving Loading Mechanism using FastloadWhat was not clear (and I did not read every reply) is whether the data from these 40,000 files must be loaded into a single table.If so, has any thought been given to using TPT (Teradata Parallel ...
1103 Jun 2009 @ 07:55 PDTToolsReplyTD Parallel Transporter DDL OperatorThe DDL operator cannot execute any SQL statements that return data (i.e. a RECORD parcel) back to the operator.However, I do not believe the COLLECT STATISTICS request actually returns data to the...
1003 Jun 2009 @ 07:49 PDTToolsReply2665 Invalid Date error in Teradata Parallel Transporter.Please supply the schema definition of your TPT script.For TAB delimited files, the schema definition must be all VARCHAR.

Pages