-532 THE RELATIONSHIP `constraint-name` RESTRICTS THE DELETION OF ROW WITH RID X `rid-number`

Explanation
  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.

SQLSTATE
  23504 

-532 THE RELATIONSHIP constraint-name RESTRICTS THE DELETION OF ROW WITH RID X rid-number

Explanation

System action

Programmer response

SQLSTATE

-532 THE RELATIONSHIP `constraint-name` RESTRICTS THE DELETION OF ROW WITH RID X `rid-number`