SQLCCSID

Use the SQLCCSID compiler option to control whether the CODEPAGE compiler option will influence the processing of SQL statements in your COBOL programs.

SQLCCSID option syntax

Read syntax diagramSkip visual syntax diagramSQLCCSIDNOSQLCCSID

Default is: SQLCCSID

Abbreviations are: SQLC | NOSQLC

The SQLCCSID option has an effect only if you use the integrated Db2® coprocessor (SQL compiler option).

If SQLCCSID is in effect, the setting of the CODEPAGE compiler option will influence the processing of SQL statements within your COBOL programs when you use the integrated Db2 coprocessor.

Start of changeIf NOSQLCCSID is in effect:
  1. The CODEPAGE compiler option will only be used as the encoding for string literals and the COBOL application source that includes converted SQL statements;
  2. Db2 (character string) host variables will not be affected by the CODEPAGE compiler option. Instead, the encoding for Db2 (character string) host variables will come from the CCSID value found in the DSNHDECP file, which means Db2 (via DSNHDECP) determines the encoding of the Db2 data (host variables).
End of change