To set the application server default character subtype, you must update a row in the SYSTEM.SYSOPTIONS catalog table. You must have DBA authority to do so. The CHARSUB option specifies the default subtype for a column when SUBTYPE clause or the CCSID is not specified explicitly (for example, on a CREATE TABLE or ALTER TABLE statement).
| Note: | The character subtype is defined for the application server only. It is not defined for the application requester. The CREATE PACKAGE CHARSUB option or the preprocessor CHARSUB option defines the default subtype for a package. For more information on this option, see the DB2 Server for VSE & VM Application Programming or the DB2 Server for VSE & VM SQL Reference manuals. |
The initial setting of the application server default character subtype is SBCS. To set it to mixed, issue:
UPDATE SYSTEM.SYSOPTIONS
SET VALUE = 'MIXED'
WHERE SQLOPTION = 'CHARSUB'
To reset the application server default character subtype to SBCS, issue:
UPDATE SYSTEM.SYSOPTIONS
SET VALUE = 'SBCS'
WHERE SQLOPTION = 'CHARSUB'
In both situations, the new setting does not become effective immediately. The new setting is not in effect until the next time the application server is started.
If anything other than 'MIXED' or 'SBCS' is specified for the application server default character subtype in the SYSOPTIONS table, SBCS is assumed and an error message is issued when the application server is started.
The application server default character subtype can only be mixed when the application server default CHARNAME is mixed. The application server default character subtype is forced to be SBCS when the application server default CHARNAME is an SBCS CHARNAME.