In this post, you’ll learn about the error message -634 the delete rule must not be cascade in the IBM DB2 database , the reason why it occurs along with the solution to fix it
IBM DB2 Error Message
-634 the delete rule must not be cascade
Reason for the Error
The code is used to report that the CASCADE delete rule specified in the FOREIGN KEY clause of an ALTER TABLE statement is invalid because: *�� The relationship would form a cycle that would cause a table to be delete connected to itself. *�� The relationship would cause another table to be delete connected to the same table through multiple paths with different delete rules or with a delete rule equal to SET NULL.
Solution
Change the delete rule.
