SQLCCSID

SQLCCSID controls whether the CODEPAGE compiler option influences the processing of SQL statements when the SQL compiler option is in effect.

Syntax

Read syntax diagramSkip visual syntax diagramSQLCCSID=*YESNO
Default
SQLCCSID=YES
YES
Indicates that the CODEPAGE compiler option setting will influence the processing of SQL statements within the source program when the integrated Db2® coprocessor (SQL compiler option) is used.
NO
Indicates that the CODEPAGE compiler option setting will only be used as the encoding for string literals and the COBOL application source that includes converted SQL statements. 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).
Notes:
  • The SQLCCSID option is supported when the LP(64) compiler option is in effect, which behaves in the same way as in LP(32).
  • The SQLCCSID option has an effect only when you use the integrated Db2 coprocessor (SQL compiler option).
  • The NOSQLCCSID option is recommended for applications that require the highest compatibility with the behavior of the Db2 precompiler.

Related references  
SQLCCSID (Enterprise COBOL Programming Guide)