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

SQLCODE -407

NULL not allowed

Explanation

Attempted to insert NULL into NOT NULL column.

Solution

Provide a value for the column, set default value, or alter column to allow NULL.

Example

INSERT INTO TABLE (NOT_NULL_COL) VALUES (NULL)