Archives of the TeradataForum
Message Posted: Tue, 14 Nov 2000 @ 19:04:05 GMT
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
|