Home Page for the TeradataForum

Archives of the TeradataForum

Message Posted: Wed, 26 May 1999 @ 17:27:10 GMT

  <Prev Next>   <<First <Prev

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).

  <Prev Next>   <<First <Prev
  Top Home Privacy Feedback  
Copyright for the TeradataForum (TDATA-L), Manta BlueSky    
Copyright 2016 - All Rights Reserved    
Last Modified: 28 Jun 2020