logo  
Google
 

DB2 SQL-Error: -632

SQLState: 42915

Short Description: THE TABLE CANNOT BE DEFINED AS A DEPENDENT OF BECAUSE OF DELETE RULE RESTRICTIONS

This code is used to report that the object of an ALTER TABLE statement cannot be defined as a dependent of the indicated table because either: v The relationship would form a cycle that would cause the table to be delete-connected to itself. v The relationship would cause the table to be delete-connected to the indicated table through multiple paths and the delete rule of the existing relationship is SET NULL.The error is due to the delete rules of existing relationships, not the delete rule specified in the FOREIGN KEY clause of the ALTER TABLE statement. System action: The statement cannot be executed. Programmer response: Eliminate the particular FOREIGN KEY clause from the ALTER or CREATE TABLE statement.

 <-  BACK TO INDEX