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
 

 

Getting SQLCODE -530

 
Post new topic   Reply to topic    IBMMAINFRAMES.com Support Forums -> DB2
View previous topic :: :: View next topic  
Author Message
soumyaranjan007

New User


Joined: 30 Aug 2006
Posts: 30
Location: mumbai

PostPosted: Mon Apr 16, 2007 1:31 pm    Post subject: Getting SQLCODE -530
Reply with quote

Hi,

we are getting SQLCODE -530. if anybody have idea in resolution. help me out.

thanks,
soumya
Back to top
View user's profile Send private message

ragganga

New User


Joined: 22 Jan 2007
Posts: 18
Location: bangalore

PostPosted: Mon Apr 16, 2007 1:54 pm    Post subject:
Reply with quote

Hi Soumya,

SQLCODE = -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 primary key of the parent table.When a row is inserted into a dependent table, the insert value of a foreign key must be equal to the value of the primary key of some row of the parent table in the associated relationship.When the value of the foreign key is updated, the update value of a foreign key must be equal to the value of the primary key of some row of the parent table of the associated relationship.

Response - Examine the insert or update value of the foreign key first, and then compare it with each of the primary key values of the parent table to determine the cause of the problem.

I think it is enough to solve your error

Regards
Raghu
Back to top
View user's profile Send private message
mkk157

Active User


Joined: 17 May 2006
Posts: 310

PostPosted: Mon Apr 16, 2007 1:59 pm    Post subject:
Reply with quote

Hi Sowmyaranjan,

I never heard about the resolution. Can u explain ur problem a bit clearly. The follwoing information about the SQLCODE -530 may help u.


-530 THE INSERT OR UPDATE VALUE OF FOREIGN KEY constraint-name IS
INVALID

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.

When a row is inserted into a dependent table, the insert value of a
foreign key must be equal to the value of the parent key of some row of
the parent table in the associated relationship.

When the value of the foreign key is updated, the update value of a
foreign key must be equal to the value of the parent key of some row of
the parent table of the associated relationship.

System Action: The UPDATE or INSERT statement cannot be executed. The
object table is unchanged.

Programmer Response: Examine the insert or update value of the foreign
key first, and then compare it with each of the parent key values of the
parent table to determine the cause of the problem.
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 -> DB2 All times are GMT + 6 Hours
Page 1 of 1

 

Search our Forum:

Similar Topics
Topic Author Forum Replies Posted
No new posts SQLCODE-000000080N priya91 DB2 1 Mon Feb 01, 2016 4:35 pm
No new posts Need to understand SQLCODE = 12 rohanthengal DB2 3 Thu Nov 05, 2015 11:22 am
No new posts SQLCODE -922 in Batch-Cics program tr... kishpra CICS 2 Thu Sep 10, 2015 12:36 pm
No new posts SQLCODE -450 for stored procedure spoorni DB2 3 Fri Jan 16, 2015 2:45 am
No new posts -81 SQLCODE returned when Remote Stor... kameswaramanoj.Akella DB2 1 Wed Dec 03, 2014 5:36 am


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