-20210   THE SQL STATEMENT CANNOT BE EXECUTED BECAUSE IT WAS PRECOMPILED AT A LEVEL THAT IS INCOMPATIBLE WITH THE CURRENT VALUE OF THE ENCODING BIND OPTION OR SPECIAL REGISTER

Explanation

The SQL statement was precompiled at a level prior to DB2® Version 7, but the current value of the ENCODING bind option or special register does not represent the system EBCDIC CCSIDs. The information that is necessary to execute the SQL statement is unavailable for processing, and the SQL statement cannot be successfully completed. Additional processing of the SQL statement is terminated.

An application that was precompiled prior to DB2 Version 7 may not be bound, either implicitly or explicitly, with an ENCODING bind option of anything other than ENCODING(EBCDIC) or ENCODING(ccsid) where ccsid represents the system EBCDIC CCSID. If the value of MIXED DATA for the system is YES, then ccsid must be the default EBCDIC mixed CCSID. Otherwise, ccsid must be the default EBCDIC single byte CCSID.

System action

The statement cannot be processed.

Programmer response

To correct the situation, you can:
  • Precompile the program again using the current precompiler and reissue the BIND command
  • Reissue the BIND command using ENCODING(EBCDIC) or ENCODING(ccsid) where ccsid represents the system EBCDIC CCSID.

SQLSTATE

560B8