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

SQLCODE -530

Foreign key constraint violation

Explanation

Insert/Update would create orphan row - parent key not found.

Solution

Ensure parent row exists before inserting child. Check referential integrity.

Example

INSERT child row where parent DEPTNO does not exist