CCSID

This option specifies that UNLOAD PLUS uses up to three CCSIDs to encode the unloaded data.

Related topic

Basic-processing-options

CCSID.png

The three CCSIDs are for single-byte character set (SBCS), MIXED data, and double-byte character set data (DBCS) respectively. If you omit a CCSID value or specify 0, UNLOAD PLUS uses the corresponding Db2 system default CCSID for the encoding scheme that you specify or default to (EBCDIC, ASCII, or UNICODE). For more details, see Data-translation.

We recommend that you use this option only to override your Db2 system default CCSID values.

Restrictions

UNLOAD PLUS supports translation from one CCSID to another with the following restrictions:

  • Translations that require the use of a conversion procedure are not supported.
  • UNLOAD PLUS ignores this option if you also specify FORMAT BMCLOAD.
  • If you also specify the UNICODE option when DIRECT YES is in effect, UNLOAD PLUS ignores any CCSID specification.

 

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