logo  
Google
 

DB2 SQL-Error: -633

SQLState: 42915

Short Description: THE DELETE RULE MUST BE

The code is used to report that the 'delete-rule' specified in a FOREIGN KEY clause of the ALTER TABLE statement is invalid. The indicated 'delete-rule' is required because: v A self-referencing constraint must have a 'delete-rule' of CASCADE or NO ACTION. v The relationship would cause the table to be delete-connected to the same table through multiple paths and such relationships must have the same 'delete-rule'.System action: The statement cannot be executed. Programmer response: Change the 'delete rule' in the FOREIGN KEY clause.

 <-  BACK TO INDEX