DEF ENCODING SCHEME field (ENSCHEME DECP value)
The ENSCHEME DECP value specifies the default format in which data is to be stored in DB2®.
| Acceptable values: | EBCDIC, ASCII, UNICODE |
| Default: | EBCDIC |
| Update: | not recommended |
| dsnhdecp: | ENSCHEME |
If you set DEF ENCODING SCHEME to ASCII or EBCDIC and MIXED DATA is set to YES, specify a mixed CCSID.
The DDL uses the default encoding scheme in the following cases:
- CREATE DATABASE
- CREATE DISTINCT TYPE
- CREATE FUNCTION
- CREATE GLOBAL TEMPORARY TABLE
- DECLARE GLOBAL TEMPORARY TABLE
- CREATE TABLESPACE (in DSNDB04 database)