What is the cascade rule and how does it relate to deletions made with a subselect. The cascade rule will not allow deletions based on a subselect that references the same table from which the deletions are being made?

Interview Candidate
Oct 13th, 2004
1
1988

First
Prev
Next
Last

Showing Answers 1 - 1 of 1 Answers

javid

Mar 20th, 2006

Cascade rule is one of the RI constraint. Which allows deletion of FK from the Dependent table if the PK from the parent is deleted. If we try to delete record from the parent that is not in the child we will see abend code -532.