Archives of the TeradataForum
Message Posted: Tue, 14 Nov 2000 @ 19:04:05 GMT
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?
|Copyright 2016 - All Rights Reserved|
|Last Modified: 15 Jun 2023|