Home Page for the TeradataForum
 

Archives of the TeradataForum

Message Posted: Thu, 08 Dec 2005 @ 20:38:09 GMT


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


Subj:   Re: Fastload (pc .txt file)
 
From:   Prescott, Kyle

For TEXT record formats, you need a record terminator at the end of each record. On the Windows platform that is Carriage return and line feed characters consecutive ('0D0A'xc). For UNIX, it is line feed ('0A'xc).

VARTEXT allows you to use column delimiters (i.e. pipe, comma, etc.), but you need the same record terminators as TEXT in order for the data to be parsed correctly.

You could use SET RECORD UNFORMATTED, but you have to account for all the bytes - including any record terminator.

     H1_ACCT    (CHAR  (09)),
     BASEINC1   (CHAR  (10)),
     BASEINC2   (CHAR  (10)),
     BASEINC3   (CHAR  (10)),
     CRLF       (CHAR  (02))

Kyle Prescott
UnumProvident



     
  <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