Chapter 8: Understanding the Transfer Process

Error reporting for transfer processing

You can use one of three methods to obtain error information about transfer processing:

Include the with report phrase in the transfer statement. When you include this phrase, the DB2 access service returns a result set containing one VARCHAR column and one row that indicates the number of rows transferred, rejected, and modified during processing.
Immediately after a transfer process, execute the following:

select @@RejectedRowCount

select @@DefaultedRowCount

These global variables return the number of rejected or defaulted rows.
Set SendWarningMessages to yes, so that the DB2 access service returns warning messages to the client when data conversion errors occur.