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
 

 

Delete a row

 
Post new topic   Reply to topic    IBMMAINFRAMES.com Support Forums -> DB2
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    Post subject: Delete a row
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    Post subject:
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    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 JCL to delete component in a package sundaram.naveen Compuware & Other Tools 14 Tue Nov 29, 2016 6:21 pm
No new posts How to delete second instance from Fl... Gunapala CN DFSORT/ICETOOL 6 Tue Oct 18, 2016 11:42 pm
No new posts Delete record or Reset RC code using ... mpawan Compuware & Other Tools 4 Tue Jul 26, 2016 3:52 pm
No new posts Delete VSAM File Records amitc23 CICS 6 Sun Apr 10, 2016 10:10 am
No new posts DB2 Stored Procedure - Dynamic SQL - ... GuyC DB2 2 Wed Feb 17, 2016 5:10 pm


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