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. 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.