Limited supportBMC provides limited support for this version of the product. As a result, BMC no longer accepts comments in this space. If you encounter problems with the product version or the space, contact BMC Support.BMC recommends upgrading to the latest version of the product. To see documentation for that version, see UNLOAD PLUS for DB2 13.1.

DISCARDS


Specify the DISCARDS option to define the limit on the number of records that UNLOAD PLUS discards.

DISCARDS.png

The default is DISCARDS 0 (no limit).

Records that UNLOAD PLUS discards for any reason count toward the limit that you specify with the DISCARDS option. UNLOAD PLUS terminates if it reaches the discard limit.

UNLOAD PLUS discards records that have the following types of errors:

  • Conversion errors
  • Rejected records based on a user-written exit routine
  • SYSREC records truncated due to the length of LOB or XML data

UNLOAD PLUS does not write the discarded records to any data set.

For related details about the role that the DISCARDS option plays during character conversion when UNLOAD PLUS is unloading fields that result in SUBBYTE AND ERRORBYTE processing, see SUBBYTE and ERRORBYTE.

 

Tip: For faster searching, add an asterisk to the end of your partial query. Example: cert*