Home Page for the TeradataForum

Archives of the TeradataForum

Message Posted: Tue, 15 Nov 2000 @ 04:58:37 GMT

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

Subj:   Re: MLoad FORMAT Error
From:   Eric J. Kohut


You say that the flat file is fixed in length but then you define the last field as varchar.

You should define this as char and then cast the value to varchar in the insert clause.

The varchar definition should have extra bytes telling how long it is, but in your case for this input file these bytes don't exist, hence the error in reading the file.


Eric J. Kohut
Senior Solutions Consultant - Teradata Solutions Group - Retail
NCR Corp.

  <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: 28 Jun 2020