Details of Rejected rows from DB2 Import

rockycj_dba · #1 (**permalink**) 08-23-10, 13:14

I'm using DB2 v 9.1 LUW. I'm importing a pipe-delimited text file and want to know if there is a way of outputting the rejected records into a text file?

SQL3149N "30467" rows were processed from the input file. "0" rows were
successfully inserted into the table. "30467" rows were rejected.

If so, could please give me an example or details on how to do this?

Thank you.

CC

n_i · #2 (**permalink**) 08-23-10, 14:41

The import message file (the one you specify with the MESSAGES clause) list every problem line. The LOAD command can move failing lines into the exception table.

Internet Services

Web Development

Digital Marketing

Consumer Tech