DB2 Error Code – -532 the relationship constraint name restricts the deletion of row with rid x’rid number’

In this post, you’ll learn about the error message -532 the relationship constraint name restricts the deletion of row with rid x’rid number’ in the IBM DB2 database , the reason why it occurs along with the solution to fix it

IBM DB2 Error Message

-532 the relationship constraint name restricts the deletion of row with rid x’rid number’

Reason for the Error

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 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 the deletion cascades to a row which is a dependent in a relationship with a delete rule of RESTRICT.

Solution

Change the program to DELETE CHILD table row before DELETE of row on PARENT table.