Thread: load utility - null values
12-22-10, 17:37 #1Registered User
- Join Date
- Dec 2010
Unanswered: load utility - null values
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:
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?
12-24-10, 04:07 #2Registered User
- Join Date
- Jun 2007
you need to have a valid mask for the load.
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 mainframeDick Brenholtz, Ami in Deutschland