Portal | Manuals | References | Downloads | Info | Programs | JCLs | Master the Mainframes
IBM Mainframe Computers Forums Index
 
Register
 
IBM Mainframe Computers Forums Index Mainframe: Search IBM Mainframe Forum: FAQ Memberlist Usergroups Profile Log in to check your private messages Log in
 

 

Job abends with SQL CODE -530 RC08

 
Post new topic   Reply to topic    IBMMAINFRAMES.com Support Forums -> ABENDS & Debugging
View previous topic :: :: View next topic  
Author Message
Nepolean R

New User


Joined: 07 Aug 2009
Posts: 1
Location: Coimbatore

PostPosted: Fri Aug 07, 2009 10:39 am    Post subject: Job abends with SQL CODE -530 RC08
Reply with quote

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?
Back to top
View user's profile Send private message

dick scherrer

Site Director


Joined: 23 Nov 2006
Posts: 19270
Location: Inside the Matrix

PostPosted: Fri Aug 07, 2009 7:14 pm    Post subject:
Reply with quote

Hello,

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.
Back to top
View user's profile Send private message
View previous topic :: :: View next topic  
Post new topic   Reply to topic    IBMMAINFRAMES.com Support Forums -> ABENDS & Debugging All times are GMT + 6 Hours
Page 1 of 1

 

Search our Forum:

Similar Topics
Topic Author Forum Replies Posted
No new posts JCL to Set Return code based on DB2 S... vinu78 DB2 17 Mon Mar 13, 2017 9:47 pm
No new posts IMS region inactive - User abend code... gthmrj IMS DB/DC 5 Tue Mar 07, 2017 12:29 pm
No new posts CA Workload Automation event code help vinu78 CA Products 10 Wed Mar 01, 2017 10:05 am
No new posts MAX-RC 88 and Return code 606 in DFH0... lind sh CICS 2 Tue Jan 24, 2017 1:23 pm
No new posts How to Capture the Max return code of... anilkumar922 All Other Mainframe Topics 2 Thu Jan 12, 2017 12:02 pm


Facebook
Back to Top
 
Mainframe Wiki | Forum Rules | Bookmarks | Subscriptions | FAQ | Tutorials | Contact Us