Archives of the TeradataForum

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

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

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>>