Portal | Manuals | References | Downloads | Info | Programs | JCLs | Mainframe wiki | Quick Ref
IBM Mainframe Computers Forums Index
 
Register
 
IBM Mainframe Computers Forums Index Mainframe: Search IBM Mainframe Forum: FAQ Memberlist 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 Speed-up/reduce CPU use of code prino PL/I & Assembler 0 Tue Sep 26, 2017 12:05 am
This topic is locked: you cannot edit posts or make replies. how to code for GDG in Rexx cvnlynn CLIST & REXX 13 Wed Aug 09, 2017 9:13 pm
This topic is locked: you cannot edit posts or make replies. rexx code to create a ps file Bharath Vikraman CLIST & REXX 4 Mon Aug 07, 2017 10:30 am
No new posts I want to retire TRX and use only Rex... Abhinav Sharma CLIST & REXX 6 Sat Jul 29, 2017 2:53 am
No new posts UNIT=AFF for Easytrieve code gandikk JCL & VSAM 7 Wed Jul 12, 2017 11:42 pm

Facebook
Back to Top
 
Job Vacancies | Forum Rules | Bookmarks | Subscriptions | FAQ | Polls | Contact Us