CCSID
The three CCSIDs are for single-byte character set (SBCS), MIXED data, and double-byte character set data (DBCS) respectively. If you specify 0 to omit a CCSID value,
BMC AMI Unload
uses the corresponding Db2 system default CCSID for the encoding scheme that you specify or default to (EBCDIC, ASCII, or UNICODE).
BMC recommends that you use this option only to override your Db2 system default CCSID values.
Restrictions
BMC AMI Unload supports translation from one CCSID to another with the following restrictions:
- Translations that require the use of a conversion procedure are not supported.
- When using DIRECT NO, translations to UNICODE are not supported except when the input and output CCSIDs are the same, such as UNICODE SBCS to SBCS, UNICODE MIXED data to MIXED data, and UNICODE DBCS to DBCS.
- BMC AMI Unload ignores this option if you also specify FORMAT UNLOAD.
Tip: For faster searching, add an asterisk to the end of your partial query. Example: cert*