logo  
Google
 

DB2 SQL-Error: -532

SQLState: 23504

Short Description: THE RELATIONSHIP RESTRICTS THE DELETION OF ROW WITH RID X

A DELETE operation attempted to delete a specified parent row in the object table and all related descendent rows in the descendent tables. However, a delete rule of RESTRICT or NO ACTION was specified for one or more descendent tables. A row of the table cannot be deleted because it has a dependent in a relationship with a delete rule of RESTRICT or NO ACTION or the deletion cascades to a row which is a dependent in a relationship with a delete rule of RESTRICT or NO ACTION. If the statement that failed is an ALTER TABLE with ALTER PART ROTATE FIRST TO LAST, then there is a referential constraint that is defined with DELETE RESTRICT on the table, and the data in the partition that is to be reused cannot be deleted because of the referential constraint. System action: The DELETE statement cannot be executed. The contents of the object table are unchanged. Programmer response: Examine the delete rule for all descendent tables to determine the cause of the problem. The specific tables involved can be determined from the relationship 'constraint-name'. The specific descendent row is known by RID X'rid-number'.

 <-  BACK TO INDEX