var sidebar_align = 'right';
var content_container_margin = parseInt('290px');
var sidebar_width = parseInt('270px');
Unanswered: Details of Rejected rows from DB2 Import
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?
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.