DB2 Error Code – -536 the delete statement is invalid because table table name can be affected by the operation

In this post, you’ll learn about the error message -536 the delete statement is invalid because table table name can be affected by the operation in the IBM DB2 database , the reason why it occurs along with the solution to fix it

IBM DB2 Error Message

-536 the delete statement is invalid because table table name can be affected by the operation

Reason for the Error

A DELETE operation with the indicated table referenced in a subquery was attempted.If ‘T’ is the object table of the DELETE, the indicated table is one of the following: *�� A dependent of ‘T’ in a relationship with a delete rule of CASCADE or SET NULL *�� A dependent of another table in a relationship with a delete rule of CASCADE or SET NULL in which deletions from ‘T’ can cascade to that table.

Solution

Do not attempt to reference a table in a subquery of a DELETE statement when the table can be affected by the DELETE statement.