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 How to Capture the Max return code of... anilkumar922 All Other Mainframe Topics 0 Thu Jan 12, 2017 12:02 pm
This topic is locked: you cannot edit posts or make replies. Calling REXX code from ISPF panel sanchita dey TSO/ISPF 4 Mon Jan 02, 2017 5:13 pm
No new posts PL/I code tuning/Performance improvement Virendra Shambharkar PL/I & Assembler 4 Mon Dec 05, 2016 11:57 am
No new posts What is the code in CLIST to enable t... jackzhang75 CLIST & REXX 1 Fri Dec 02, 2016 3:02 am
No new posts IDEAL - Code Retrieval yugendran CA Products 0 Fri Nov 25, 2016 3:27 pm


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