Home Page for the TeradataForum
 
https:

Archives of the TeradataForum

Message Posted: Tue, 05 Mar 2002 @ 15:23:30 GMT


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


Subj:   Re: Creating a UNIX fastload
 
From:   Geoffrey Rommel

With "set record unformatted", FastLoad will treat the file as nothing more than a string of bytes. You must therefore account for every single byte in the file. I assume that you have a fixed-length Unix text file; if so, every line is terminated by a LineFeed (x'0A', a.k.a. "\n"). Add a filler byte to your DEFINE command like so:

DEFINE
       MINE_ID       (CHAR(7)),
       CURR_OWNR     (CHAR(7)),
       CASE_NAME     (CHAR(25)),
       MINE_IND      (CHAR(1)),
       LINE_FEED     (CHAR(1))
       FILE =vcondata;

Good luck!

--wgr



     
  <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