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

SQLCODE -539

Foreign key not nullable

Explanation

Foreign key column cannot be set to NULL with SET NULL rule.

Solution

Make FK column nullable or use different delete rule.

Example

NOT NULL FK with ON DELETE SET NULL