34 | 10 Sep 2009 @ 02:31 PDT | Tools | Reply | Verify Version loaded | Another 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... |
33 | 03 Sep 2009 @ 10:26 PDT | Tools | Reply | How to Convert VARCHAR(30) to a DATE in Fastload | If 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... |
32 | 03 Sep 2009 @ 06:37 PDT | Tools | Reply | How to Convert VARCHAR(30) to a DATE in Fastload | I 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... |
31 | 25 Aug 2009 @ 09:07 PDT | Tools | Reply | How 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. |
30 | 12 Aug 2009 @ 02:22 PDT | Tools | Reply | How to fetch records using CLIv2 | It 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... |
29 | 12 Aug 2009 @ 02:10 PDT | Tools | Reply | Number of Sessions | It 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... |
28 | 12 Aug 2009 @ 02:07 PDT | Tools | Reply | Error Accessing Fast Export Utility | Leave that field blank. |
27 | 04 Aug 2009 @ 10:37 PDT | Tools | Reply | Fastload 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.
|
26 | 04 Aug 2009 @ 10:36 PDT | Tools | Reply | Fastload 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... |
25 | 31 Jul 2009 @ 03:32 PDT | Tools | Reply | Fastload 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... |
24 | 31 Jul 2009 @ 10:36 PDT | Tools | Reply | Fastload 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?
|
23 | 30 Jul 2009 @ 01:47 PDT | Tools | Reply | Flat files to Teradata tables | Teradata 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. |
22 | 30 Jul 2009 @ 01:46 PDT | Tools | Reply | DB2 database to teradata | Teradata Parallel Transporter has an ODBC operator that will enable the user to move data fromDB2 to Teradata using ODBC. |
21 | 30 Jul 2009 @ 11:06 PDT | Tools | Reply | Fastload 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... |
20 | 29 Jul 2009 @ 02:50 PDT | Tools | Reply | TPT error code 29 | Please 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... |
19 | 24 Jul 2009 @ 08:30 PDT | Tools | Reply | Improving Loading Mechanism using Fastload | Depending 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 ... |
18 | 24 Jul 2009 @ 08:23 PDT | Tools | Reply | TD ParellelTransporter | You 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... |
17 | 01 Jul 2009 @ 10:10 PDT | Tools | Reply | FastLoad Error -incorrect number of bytes returned | Looks like you are using delimited data.Any reason why you are not using SET RECORD VARTEXT? |
16 | 01 Jul 2009 @ 10:09 PDT | Tools | Reply | TPT error | Are 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... |
15 | 10 Jun 2009 @ 01:12 PDT | Tools | Reply | Why 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... |
14 | 10 Jun 2009 @ 01:09 PDT | Tools | Reply | Problem with TPT 12 | You 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... |
13 | 10 Jun 2009 @ 01:06 PDT | Tools | Reply | TD Parallel Transporter DDL Operator | Which 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 ... |
12 | 03 Jun 2009 @ 08:01 PDT | Tools | Reply | Improving Loading Mechanism using Fastload | What 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 ... |
11 | 03 Jun 2009 @ 07:55 PDT | Tools | Reply | TD Parallel Transporter DDL Operator | The 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... |
10 | 03 Jun 2009 @ 07:49 PDT | Tools | Reply | 2665 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. |