A job often abends with RC 08 SQLCODE -530 in production when processing components of certain applications. This abend occurs during the execution of the JS0050 step in the job. This step is responsible for updating the control database with values of the loaded components. We tried replicating this abend in test, but the job went through fine and so we are unable to analyze the problem. We even copied the production data to test to exactly reproduce this abend, but still the job runs without any errors in test. Given below is the explanation of SQL -530.
Explanation: An UPDATE or INSERT operation attempted to place a value in
a foreign key of the object table; however, this value was not equal to
some value of the parent key of the parent table.
Can anyone please help?
Joined: 23 Nov 2006 Posts: 19270 Location: Inside the Matrix
This is because the foreign key is not in the "other" table.
The code needs to show what value raised the error. The missing value needs to be inserted in the "other" table or removed from the data to be inserted.
If there was a department table and a people table, one fo the rules might be that to add a person, they must have an already defined department in the department table. So department-no is set up as a foreign key. Any attempt to insert a person into a non-existent department wil fail.