Hi ,

I have a pipe-delimited file which I load using the DB2 Load utility command , and some of the rows do not have values for the respective columns.

I am aware of the Null indicator that can be used in the DB2 Load command , but that applies only for ASCII files.

How can I implement the Null indicator for the pipe 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

no problem - if column is allowed/created with NULL the load will continue and load a NULL for an empty or not specified column
you will only get errors if column was created with NOT NULL and not loading this column or loading an empty value