Archives of the TeradataForum
Message Posted: Sun, 20 Jun 2004 @ 15:58:22 GMT
Subj: | | Re: During MLOAD, is there a way to re-route to a flat file rows that fails to load? |
|
From: | | Prescott, Kyle R |
I believe you will find your data record in the HostData column of the table. The SourceSeq column identifies the source sequence or record
number of the input data file and the host data contains actual data (64KB maximum size data row).
The host data column can be exported back to the platform from which it came (UNIX/W2K or MVS) - or inspected in place. The host data parcel
is in native format from the platform acquired - which means binary EBCDIC for channel attached MVS or binary ASCII for network attached
(UNIX/W2K).
Kyle Prescott
Teradata Certified Professional
UnumProvident - Data Strategies
|