i have a table, TBL like COL1, COL2, COL3, All can have nulls.

i'm using the db2 load utility to load data from a tab delimited file that looks like:

DATA\tDATA\tDATA
DATA2\tDATA2\tDATA2
\tDATA3,DATA3
DATA4\t\tDATA4

My load command looks like:

LOAD DATA LOG NO INDDN SYSREC00
FORMAT DELIMITED COLDEL X'05'
INTO TABLE MYTABLE

This keeps crashing on loading the rows that should have null data. (records 3 and 4). I'm told

DSNU1044I DSNUGTIS - PROCESSING SYSIN AS EBCDIC
0DSNU050I DSNUGUTC - LOAD DATA LOG NO INDDN SYSREC00 FORMAT DELIMITED COLDEL X'05'
DSNU650I - DSNURWI - INTO TABLE TBL
DSNU650I - DSNURWI - (COL1,
DSNU650I - DSNURWI - COL2,
DSNU650I - DSNURWI - COL3
DSNU650I - DSNURWI - )
DSNU334I - DSNURCON - INPUT FIELD 'COL2' INVALID FOR 'TBL', ERROR CODE '12'
DSNU302I - DSNURWBF - (RE)LOAD PHASE STATISTICS - NUMBER OF INPUT RECORDS PROCESSED=2

Any help on how i can do this would be appreciated. It seems like the load requires data for all the fields getting loaded?

you need to have a valid mask for the load.
on mainframe
since i also don't bother to read the manual
i usually execute an unload parmed to generate the correct mask, output dd is syspunch on mainframe