DSNH4791I csect-name CCSID ccsid-1 IS USED TO PROCESS SQL, BUT DSNHDECP HAS EBCDIC CCSID ccsid-2 IN EFFECT
Explanation
The Db2 coprocessor is using CCSID ccsid-1 to process SQL. ccsid-1 is different from the ccsid-2, which was loaded from the DSNHDECP module.
- csect-name
- The name of the control section that issued the message.
- ccsid-1
- The CCSID that was used to process SQL statements.
- ccsid-2
- The CCSID that was loaded from the DSNHDECP module. ccsid-2 is SCCSID if the MIXED DATA field is NO in DSNHDECP, or MCCSID if the MIXED DATA field is YES.
System action
Processing continues.
User response
Ensure that the CCSIDs specified for compilation is the CCSID intended for processing SQL. Processing SQL with a CCSID different from the CCSID used in database tables can lead to unexpected results. The CCSID that is used to interpret data in host variables can be from the DSNHDECP module, the ENCODING BIND option, a CCSID specified on the DECLARE VARIABLE statement or specified as a compile option such as CCSID0 for PL/I or SQLCCSID for COBOL.
Check the program listing for message DSNH527I, which was issued if the coprocessor is using the Db2-supplied DSNHDECP module. If it is not intended to use the Db2-supplied DSNHDECP module, refer to the description of DSNH527I to take corrective action.
Severity
4 (warning)