LOAD utility delimited input file format
Problem
Receiving abend04e-00e40323 when no COLDEL is specified on the last field of input.
Based on the Sample LOAD job with delimited input file, a delimiter is not required at the end of the input record. Is it a typo on the document or a bug on the code?
Here's the DDL for the table:
CREATE TABLE table1
(fld1 CHAR(36) NOT NULL,
fld2 CHAR(2),
fld3 TIMESTAMP NOT NULL,
fld4 SMALLINT,
fld5 CHAR(36),
fld6 SMALLINT);
Here are the load control cards:
LOAD DATA REsume no
FORMAT DELIMITED COLDEL X'4F'
LOG NO NOCOPYPEND
INTO TABLE table1
(fld1 CHAR(36),
fld2 CHAR(2),
fld3 TIMESTAMP external,
fld4 int eXTERNAL(3),
fld5 CHAR(36),
fld6 INT EXTERNAL(4))
And the input file:
2a000000-0000-0000-0000-000000000000|1|2003-06-19-00.00.00|2000|ac8|1000
Solution
The job used to run the LOAD had sequence numbers in columns 72 through 80 of the input data. This caused the LOAD job to abend.
Related information
Utility Guide and Reference: Delimited file format
P.S. Please pass my address to anyone interested in DB2 HOTLINE - thank you.
With kind regards
Michael Dewert, Software Group
DB2 Information Management Software
