Home Page for the TeradataForum

Archives of the TeradataForum

Message Posted: Sun, 20 Jun 2004 @ 15:58:22 GMT

  <Prev Next>   <<First <Prev Next> Last>>  

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

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