Specifying object CCSIDs
The default encoding scheme for all Db2 objects is the value of ENSCHEME in dsnhdecp. dsnhdecp is the DSNHDECP module or a user-specified application defaults module. However, 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 dsnhdecp).