CCSID

This option allows you to specify up to three CCSIDs for use in encoding input data.

Related topic

Basic-LOADPLUS-processing-options

CCSID.png

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

Important

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

When invoking DSNUTILB, LOADPLUS passes this option to the IBM Db2 LOAD utility for processing.

Restrictions

Note the following restrictions:

  • LOADPLUS ignores this option if you also specify FORMAT BMCUNLOAD.
  • LOADPLUS supports translation from one CCSID to another except for translations that require the use of a conversion procedure.


 

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