Code-page conversion
There are differences in the way character conversion is handled between the separate precompiler and the integrated coprocessor. View the following items to take into account these differences when you change to using the coprocessor.
- Code-page coordination between COBOL and Db2® for SQL statements
- Precompiler: There is no coordination. The code page for
processing SQL statements is determined from Db2 external mechanisms and defaults Coprocessor: Code-page coordination between COBOL and Db2 for SQL statements is dependant on the SQLCCSID compile option:
- SQLCCSID:
- The COBOL CODEPAGE(ccsid) compiler option affects processing of host variables in COBOL statements and SQL statements.
- CCSID processing is compatible with the SQL coprocessor in Enterprise COBOL V3R4.
- The ccsid specified in the CODEPAGE compiler option must match the ccsid in DSNHDECP for the database encoding.
- NOSQLCCSID (recommended):
- The CODEPAGE(ccsid) compiler option only affects processing of COBOL statements, it is not used for processing SQL statements.
- The code page for processing SQL statements is determined from Db2 external mechanisms such as DSNHDECP and defaults.
For more information about SQLCCSID and NOSQLCCSID, see the Enterprise COBOL for z/OS® Programming Guide section "COBOL and Db2 CCSID determination".
- SQLCCSID: