Home Page for the TeradataForum
 

Archives of the TeradataForum

Message Posted: Fri, 23 May 2008 @ 21:48:09 GMT


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


Subj:   Fastload & pipe delimited file
 
From:   Poston, Donna

Hi all, I have been getting the following error message: Not enough fields in vartext data record number: 4

The output file resides on Unix and it was created by a BTEQ export defining the record format as text. All the columns were cast as char with a pipe concatenated to each columns. I am guessing it is the fourth record on the file, but when I issue head file_name the fourth record looks ok to me. Does anyone have any suggestions as to what I can look at to better understand the problem?


Thanks Much,

Donna


Example

     SELECT
     COALESCE(CAST(hh_id AS CHAR(13)),'~')||'|'||
     COALESCE(CAST(hh_id AS CHAR(13)),'~')||'|'||
     COALESCE(ste_cd,'~')||'|'||
     COALESCE(zip_cd,'~')||'|'||
     COALESCE(CAST(last_activity_dt AS CHAR(10)),'~')||'|'||
     COALESCE(best_cus_fl,'~')||'|'||

     ETC

The Fastload defines the record as SET RECORD VARTEXT "|" ;

     BEGIN LOADING xxx_DB.DB_Tablename
           ERRORFILES APPL.ERROR_1
                     ,APPL.ERROR_2;


     DEFINE  HH_ID            (varchar(20), nullif = '~')
            ,HH_ID2            (varchar(20) ,nullif = '~')
            ,STE_CD            (varchar(5), nullif = '~')
            ,ZIP_CD            (varchar(10), nullif = '~')
            ,LAST_ACTIVITY_DT  (varchar(15), nullif = '~')
            ,BEST_CUS_FL       (varchar(5), nullif = '~')

     ETC


     
  <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: 27 Dec 2016