Master Mainframe Technologies - COBOL, JCL, DB2, VSAM, CICS & More
ABEND Codes SQLCODEs File Status Interview Prep Contact
← Back to SQLCODE Reference
Error

SQLCODE -216

Expression incompatible

Explanation

Incompatible data types in expression or comparison.

Solution

Ensure data types match. Use CAST or conversion functions.

Example

WHERE CHAR_COL = 12345 -- Comparing CHAR to INTEGER