Archives of the TeradataForum
Message Posted: Wed, 26 May 1999 @ 17:27:10 GMT
Subj: | | Re: Data Parcel |
|
From: | | Bob Hahn |
In the most recent version of the FastLoad manual that I have (for FastLoad 7.1.0 and with number B035-2411-108A on the front), Chapter 2
has a section on "Procedure for Correcting Error in the First Error Table".
To the best of my knowledge, the data in the data parcel column is the actual data which the DBS received (the entire record). The table
on page 2-46, 2-47 and 2-48 describe how to use BTEQ to extract the data so that it can be fixed and re-loaded into the table.
I do not believe, however, that there is any way to tell from the data itself exactly which record from the data source caused the
problem (in other words, there is no way to find out if the offending record was the 10th record, or the millionth record). The Error Table
only makes the data available (along with the DBS error code which should give a clue as to the type of error and on which column the error
occurred) so that it can be fixed and re-loaded.
(This manual is available on the external Web).
|