DB2 SQL-Error: -20210
SQLState: 560B8
Short Description: THE SQL STATEMENT CANNOT BE EXECUTED BECAUSE IT WAS AT A LEVEL THAT IS INCOMPATIBLE WITH THE CURRENT VALUE OF THE ENCODING BIND OPTION OR SPECIAL REGISTER
The SQL statement was precompiled at a level prior to 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 executed. Programmer response: To correct the situation, you can: v Precompile the program again using the current precompiler and reissue the BIND command v Reissue the BIND command using ENCODING(EBCDIC) or ENCODING(ccsid) where ccsid represents the system EBCDIC CCSID.