Home Page for the TeradataForum

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:

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

Good luck!


  <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