IBM Mainframe Forum Index
 
Log In
 
IBM Mainframe Forum Index Mainframe: Search IBM Mainframe Forum: FAQ Register
 

Delete a row


IBM Mainframe Forums -> DB2
Post new topic   Reply to topic
View previous topic :: View next topic  
Author Message
kaurav

New User


Joined: 19 Oct 2005
Posts: 7

PostPosted: Mon Jan 16, 2006 2:16 pm
Reply with quote

Pls let me know the effects of ON DELETE RESTRICT and ON DELETE NO ACTION option on Referential constraints
Back to top
View user's profile Send private message
senthilssg

New User


Joined: 09 Dec 2005
Posts: 64
Location: USA

PostPosted: Mon Jan 16, 2006 4:53 pm
Reply with quote

Hi kaurav,


Quote:
Pls let me know the effects of ON DELETE RESTRICT and ON DELETE NO ACTION option on Referential constraints


what the difference is between the NO ACTION and RESTRICTED options?
The answer is that the NO ACTION option will wait until all triggers defined for the table have been executed.

you can refer this link for the details .

http://www.itjungle.com/mpo/mpo021303-story02.html


ON DELETE RESTRICT: disallows the deletion of the primary key row if any foreign keys relate to the row.

ON DELETE NO ACTION: the behavior of NO ACTION is similar to RESTRICT. The only difference between RESTRICT and NO ACTION is when the referential constraint is enforced. RESTRICT enforces the delete rule immediately; NO ACTION enforces the delete rule at the end of the statement.

you can get the details of this from following link .
http://www.dbazine.com/db2/db2-mfarticles/mullins1/



Regards ,
senthil


'CORRECT ME I 'M WRONG'
Back to top
View user's profile Send private message
View previous topic :: :: View next topic  
Post new topic   Reply to topic View Bookmarks
All times are GMT + 6 Hours
Forum Index -> DB2

 


Similar Topics
Topic Forum Replies
No new posts DELETE SPUFI DB2 1
No new posts DSNTIAUL driven delete IBM Tools 0
No new posts How to delete a user's alias from the... JCL & VSAM 11
No new posts Delete file row if blanks in the firs... DFSORT/ICETOOL 5
No new posts volume mass delete RMM JCL & VSAM 2
Search our Forums:

Back to Top