UNLD ASCII

Use this option to tell BMC AMI Unload to use the Db2 installation default (DSNHDECP) CCSIDs to encode the unloaded data in ASCII.

If you do not specify ASCII, UNICODE, or EBCDIC on the unload statement, the default is based on the encoding scheme of the unloaded table, as follows:

  • ASCII encodes data using EBCDIC CCSID defined to Db2.
  • UNICODE encodes data using EBCDIC CCSID defined to Db2.
  • EBCDIC encodes data using EBCDIC CCSID defined to Db2 if you specify MODE(AUTO), but does not encode data if you specify MODE(DIRECT).

Important

Do not use MODE(DB2SQL) or MODE(AUTO) with this option.

Related topics

Option descriptions—UNLD syntax
UNLD-syntax-diagrams
EBCDIC (UNLD syntax)
ASCII

For more information about page encoding, see Page-encoding-UNLD-command.


 

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