Home Page for the TeradataForum
 

Archives of the TeradataForum

Message Posted: Tue, 14 Nov 2000 @ 19:04:05 GMT


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


Subj:   MLoad FORMAT Error
 
From:   Dara Tressler

I am having an error which does not make sense. I have set up a fixed length flat file with just 3 lines of data in it and a test multiload program to read it into a table named foo. The multiload program is below (the logon and logtable is cut out):

     DROP TABLE wt_foo;
     DROP TABLE et_foo;
     DROP TABLE uv_foo;
     DROP TABLE foo;

     CREATE TABLE foo,
         NO FALLBACK, NO BEFORE JOURNAL, NO AFTER JOURNAL
         (f1 CHAR(3), f2 CHAR(3), f3 VARCHAR(3))
         UNIQUE PRIMARY INDEX (f1);

     .BEGIN MLOAD TABLES foo SESSIONS 4;

     .LAYOUT lay1;
     .FIELD f1 * char(3);
     .FIELD f2 * char(3);
     .FIELD f3 * varchar(3);

     .DML LABEL dml1;
     INSERT INTO foo values (:f1, :f2, :f3);

     .IMPORT INFILE foo.data
     LAYOUT lay1
     APPLY dml1;
     .END MLOAD;

     .LOGOFF;

     The datafile is below:

     111222333
     444555666
     777888999

I am getting the following error which I cannot understand:

     **** 09:06:35 UTY4015 Access module error '16' received during 'read'
     operation on record number '0': 'Unexpected data format'
     *

do I need to do something differently? (FASTLOAD would handle the load portion ok) I am used to FASTLOAD and BTEQ and maybe I need to do something different for a MULTILOAD input file.

Can anyone help?

Dara Tressler
Senior Programmer Analyst
Speedway SuperAmerica LLC



     
  <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