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

Dara,

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

EJK
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: 15 Jun 2023