MIXED DATA field (MIXED DECP value)
The value of the MIXED DECP field indicates how the EBCDIC CCSID and ASCII CCSID fields are to be interpreted by Db2.
The MIXED DATA option has no effect on a Unicode string, including a Unicode column in an EBCDIC table. Regardless of the setting for MIXED DATA, UNICODE UTF-8 data is considered mixed data and is processed according to the rules for mixed data.
| Acceptable values: | YES, NO |
|---|---|
| Default: | NO |
| Update: | not recommended |
| dsnhdecp: | MIXED |
- YES
- The CCSID that is specified in the EBCDIC CCSID and ASCII CCSID
field must be the mixed CCSID for the encoding scheme. From this, Db2 determines
the associated SBCS and DBCS CCSIDs for the encoding scheme. MIXED
DATA YES allows EBCDIC and ASCII mixed-character data and graphic
data to be defined.Important: MIXED DATA applies to both the EBCDIC CCSID and ASCII CCSID. If you choose MIXED DATA YES, you must select mixed CCSIDs for EBCDIC and ASCII.
- NO
- The CCSID specified in the EBCDIC CCSID or ASCII CCSID field must be the CCSID for the encoding scheme. MIXED DATA NO does not allow for EBCDIC or ASCII mixed character data or graphic data to be defined.
For EBCDIC data, the value specifies whether the code points X'0E' and X'0F' have special meaning as the shift-out and shift-in controls for character strings that include double-byte characters.
- NO indicates that these code points have no special meaning. Therefore, all character strings are single-byte character set (SBCS) data.
- YES indicates that these code points have the special meaning described above. Therefore, character strings can be either SBCS or MIXED data.