This statement specifies the CCS name of the user program.
Definition
A lower-level DBH option of LINKED-IN-ATTRIBUTES
Function
The DBH option CODED-CHARACTER-SET allows you to specify a coded character set which is used by the user program of a linked-in DBH. The DBH option is ignored in the independent DBH.
In the independent DBH the user program’s CCS name is not specified using a DBH option but via the user’s configuration file, see the “ Core manual”.
If a coded character set was specified for the database (CODE-TABLE ccs_name clause in the CREATE CATALOG or ALTER CATALOG statement), the CCS name of the database must match the CCS name of the user program when the user program accesses the database. Accesses by user programs using CODED-CHARACTER-SET=*NONE or by user programs from SESAM/SQL < V5.0 are rejected with SQLSTATE.
This check does not take place for the utility statements CREATE/ALTER CATALOG, CREATE/REFRESH REPLICATION and RECOVER CATALOG [SPACE]. If no coded character set was specified for the database, the check does not take place either.
CODED-CHARACTER-SET |
= *NONE / <alphanum_name 1..8> |
Operands
CODED-CHARACTER-SET = *NONE / <alphanum_name 1..8>
CCS name of the user program as defined in BS2000 (system component XHCS). The default value is *NONE, i.e. no coded character set has been defined for the user program.