59 | 14 Jan 2010 @ 11:15 PST | Tools | Reply | Data byte count error | The CLI 207 is not related to changes you made to the script. CLI 207 means CLI could not make a connection to the DBS (network is down, or something related to that; it is a catchall error code).A... |
58 | 14 Jan 2010 @ 03:48 PST | Tools | Reply | Data byte count error | Also, forgot to mention that when using "delimited" as a record format for the Dc operator, all columns in the schema definition must be of type VARCHAR. We will send the VARCHAR fields to Teradata... |
57 | 14 Jan 2010 @ 03:46 PST | Tools | Reply | Data byte count error | Ok, this might seem like a stupid question, but bears asking.The data you provided, was that the textual representation of the actual data?Or is that the exact format (text data with comma field se... |
56 | 13 Jan 2010 @ 01:52 PST | Tools | Reply | Data byte count error | I believe we would need to see the script, a copy of the console messages and even the output of the first few records (in hex if you want) of the data.Cannot help with just this provided informati... |
55 | 07 Jan 2010 @ 06:12 PST | Tools | Reply | TPT Branching | Right now, TPT does not support what we refer to as "conditional job steps" (the ability to execute the various job steps in a multi-step script based on certain conditions).
It is planned for a... |
54 | 17 Dec 2009 @ 11:56 PST | Tools | Reply | Problem in Creating Delimited Data file using FastExport. | I believe you need to tell FastExport that you do NOT want indicators (I think FastExport exports the data with the indicator bytes), and I think you need to specify a record format of TEXT (I beli... |
53 | 16 Dec 2009 @ 03:22 PST | Tools | Reply | Wildcard characters in MLoad | Or use Teradata Parallel Transporter that can load multiple files at the same time in parallel, and accepts the wildcard syntax. :) |
52 | 16 Dec 2009 @ 03:21 PST | Tools | Reply | fastexport flat file data prob | I would check your data in Teradata.FastExport does not support the notion of outputting the data in VARTEXT format.Therefore, what you see is wha tthe data actually looked like when it was exporte... |
51 | 03 Dec 2009 @ 08:51 PST | Tools | Reply | error 6760 and 2679 | Please provide script, sample of data, and table definition (DDL). |
50 | 03 Dec 2009 @ 08:50 PST | Tools | Reply | any one plz give me brief explain about this error | The table named in the error message was:Duplicate unique prime key error in database.table_Log.The "_Log" is usually the naming convention people use to specify the restart log table.I do not thin... |
49 | 03 Dec 2009 @ 03:40 PST | Tools | Reply | Error while loading multiple files in Teradata using Multiload. | Please provide the entire script.Also, are the rows placed in the ET or UV error table? |
48 | 03 Dec 2009 @ 03:39 PST | Tools | Reply | any one plz give me brief explain about this error | The error you are seeing is from MultiLoad trying to access or update the restart log table.This has nothing to do with the target, work, or error tables.Are you fully qualifying all of your table ... |
47 | 11 Nov 2009 @ 12:16 PST | Tools | Reply | Fastload error in schedule job | I think more info is needed.
What is a .CMD file?
What are its contents?
How is the job scheduled?
Is it scheduled to execute that same .CMD file?
Have you tried creating a .bat file with th... |
46 | 09 Nov 2009 @ 02:09 PST | Tools | Reply | TPT Script Multiple Table Question | TPT supports the notion of job steps. Each job step is an independent load task.So, you can create a single TPT script with 10 load tasks in them, but if you wantthe tables all moved in parallel, y... |
45 | 09 Nov 2009 @ 02:07 PST | Tools | Reply | Teradata Fast Export and Fastload Scripting Syntax | http://www.info.teradata.com/DataWarehouse/eTeradata-BrowseBy.cfm |
44 | 09 Nov 2009 @ 02:05 PST | Tools | Reply | TPT And Mainframe Chanel Attached Systems | You need to look at TPT the same way you would, say, FastLoad.TPT will connect to Teradata across the channel in the same way.So, if you are looking to move data between to Teradata systems, then y... |
43 | 04 Nov 2009 @ 05:13 PST | Tools | Reply | In TPT UPSERT on a table with an Identity Column primary index is illegal | Looking in the Teradata Messages manual, you will see this:5790 UPSERT on a table with an Identity Column primary index is illegal.Explanation: If the UPSERT table has an identity column as its pri... |
42 | 04 Nov 2009 @ 04:59 PST | Tools | Reply | In TPT UPSERT on a table with an Identity Column primary index is illegal | Which operator are you using?Update?Stream? |
41 | 04 Nov 2009 @ 04:57 PST | Tools | Reply | Teradata TPT Script | We do understand that it would be nice to not have to specify a schema object in the script, and we are working towards that goal. If you have further questions on this, do not hesitate to ask, and... |
40 | 15 Oct 2009 @ 06:24 PDT | Tools | Reply | Fast Export & Fast loading | FastExport does not support the exporting of data in delimited format.I am sure that the column values were not separated by TAB whitespace characters.TEXT format just writes the data in a format t... |
39 | 16 Sep 2009 @ 03:50 PDT | Tools | Reply | Sending data to Windows Named Pipe | When you created the pipe and you began the FastExport job, did you already have a reader attempting to read from the pipe prior to starting FastExport?
I think that is the correct order.
I thi... |
38 | 10 Sep 2009 @ 02:53 PDT | Tools | Reply | command issue in mload | SYSDAY is not a valid environment variable in your environment.The message is correct.Do not confuse "environment variable" with "pre-defined MultiLoad system variable".They are different things.Fo... |
37 | 10 Sep 2009 @ 02:41 PDT | Tools | Reply | Data Loading in Views using Fastload | No explanation needed. In case you were not aware, for the FastLoad protocol, there is special code that is executedboth on the client and on the database. Many of these restrictions are due to sof... |
36 | 10 Sep 2009 @ 02:38 PDT | Tools | Reply | CAN I WRITE ERRORED RECORDS INTO A FILE IN MLOAD? | The first item of importance is to not that the DISPLAY ERRORS and NOSTOP options only workwith VARTEXT records. It will not work with the binary formats.Next, the DISPLAY ERRORS option will indica... |
35 | 10 Sep 2009 @ 02:34 PDT | Tools | Reply | I am loading the data into files using fastexport but... | If the layout of the table consists of non-character fields (i.e. integer, decimal) then the datawill be returned to FastExport in binary format.If you want the data in text format, then you would ... |