Archives of the TeradataForum
Message Posted: Wed, 26 May 1999 @ 17:27:10 GMT
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).
|Copyright 2016 - All Rights Reserved|
|Last Modified: 15 Jun 2023|