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

SQLCODE -117

Number of values not equal to columns

Explanation

The number of insert values does not match the number of columns specified.

Solution

Verify INSERT statement has same number of values as columns. Check for missing or extra values.

Example

INSERT INTO TABLE (COL1, COL2) VALUES (:VAR1) -- Missing VAR2