Using the CCS Clause

The CCS clause specifies the translation to and from Unicode that is needed when database data and identifiers are passed between the MCP-based Query Processor components and the Windows-based Relational Design Center and the Query Design Center.

If a CCS clause is omitted, the Query Processor determines the coded character set based on the ccsversion of the database. If a ccsversion is not specified for the database and the CCS clause is omitted, then ASERIESEBCDIC is assumed.

A ccsversion is an optional specification in DASDL for a database on which the SQLVIEW command was performed. If a CCS clause and a ccsversion are specified for the database, the CCS value of the ccsversion must match the value of the CCS clause for the resource.

If 16-bit data item names, structure names, or data item types are used in DASDL for a database on which the SQLVIEW command was performed, a corresponding CCS clause must be used for the resource specification.

For a complete list of supported CCS values, refer to the MultiLingual System Administration, Operations, and Programming Guide.