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
 
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 load and delete table through JCL wit... ram_vizag JCL & VSAM 9 Thu Feb 01, 2018 12:47 am
No new posts Skip file from delete pema_yozer All Other Mainframe Topics 3 Tue Aug 29, 2017 3:19 pm
No new posts Delete IMS remote transaction when MO... Sam Singh IMS DB/DC 0 Wed Aug 23, 2017 9:12 pm
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

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