Specifying object CCSIDs

The default encoding scheme for all DB2® objects is the value of ENSCHEME in Start of changedsnhdecpEnd of change. Start of changedsnhdecp is the DSNHDECP module or a user-specified application defaults module. End of changeHowever, you can override this value for a particular object.

About this task

The ENSCHEME value was set during installation on panel DSNTIPF in the DEF ENCODING SCHEME field. Do not change the ENSCHEME DECP value without first considering the implications. This value controls the default encoding scheme of any newly created objects.

Procedure

To specify object CCSIDs:

Use the CCSID clause in the CREATE statement for any of the following objects:
  • Database
  • Table space
  • Table
  • Procedure or function

You can specify one of the following values in the CCSID clause:

ASCII
Use the subsystem default ASCII CCSID.
EBCDIC
Use the subsystem default EBCDIC CCSID.
Unicode
Use the subsystem default Unicode CCSID.

If you do not specify the CCSID clause, the object uses the subsystem default encoding scheme value (ENSCHEME in Start of changedsnhdecpEnd of change).