Home Page for the TeradataForum
 

Archives of the TeradataForum

Message Posted: Fri, 24 Feb 2006 @ 11:48:52 GMT


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


Subj:   Re: Fastload script: EOF encountered before end of
 
From:   Francesca Maffei

Hi Kishore,

I think you should remove the first and last delimiter from your file:

     8007|Smith,Ginny   |408|3792152|333|88/08/05
     8010|Brayton,Connie|408|1112345|112|87/07/21
     8005|Hughes,Jack   |212|5432126|710|87/08/05
     8001|Leblanc,James |805|2213456|221|87/08/01
     8008|Torres,Alison |802|5487890|444|88/08/14
     8015|Dibble,Nancy  |602|2713387|652|88/08/09

and probably specify the delimiter in the set record clause: "set recdord vartext '|'".

Hope this helps,


Bye,

Francesca



     
  <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