Results 1 to 2 of 2
  1. #1
    Join Date
    Dec 2010
    Posts
    8

    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:

    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?

  2. #2
    Join Date
    Jun 2007
    Location
    germany
    Posts
    155
    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
    Dick Brenholtz, Ami in Deutschland

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •