Null Indicator in DB2 Load utility for pipe Delimited files

[Vivek Kulkarni]

Hi ,

I have got a pipe delimited file which I am loading into the DB using the DB2 Load utility.
Now some of the rows in the pipe delimited file don't have the data for the respective columns , and therefore they get rejected by the Load utility.

I am aware of the Null indicator , but that is available only for ASCII files
Can anybody please guide me the Null Indicator equivalent to be used incase of delimited files.

The load command that I am using is

LOAD FROM <filename> OF DEL MODIFIED BY COLDEL| REPLACE INTO <TBL_NM> NONRECOVERABLE

Thanks in advance,
Vivek