In general, the SQLCCSID option is recommended for new applications that use the integrated DB2 coprocessor, and as a long-term direction for existing applications. The NOSQLCCSID option is recommended as a mechanism for migrating existing precompiler-based applications to use the integrated DB2 coprocessor.
The SQLCCSID option is recommended for COBOL-DB2 applications that have any of these characteristics:
The NOSQLCCSID option is recommended for applications that require the highest compatibility with the behavior of the DB2 precompiler.
For applications that use COBOL alphanumeric data items as host variables interacting with DB2 string data that is defined with the FOR BIT DATA subtype, you must either:
EXEC SQL DECLARE hostvariable VARIABLE FOR BIT DATA END-EXEC
Usage notes
related concepts
DB2 coprocessor
related references
SQLCCSID