-536 THE DELETE STATEMENT IS INVALID BECAUSE TABLE `table-name` CAN BE AFFECTED BY THE OPERATION

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

System action
 The DELETE statement cannot be processed.  The
contents of the object table are unchanged.

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

SQLSTATE
 42914

-536 THE DELETE STATEMENT IS INVALID BECAUSE TABLE table-name CAN BE AFFECTED BY THE OPERATION

Explanation

System action

Programmer response

SQLSTATE

-536 THE DELETE STATEMENT IS INVALID BECAUSE TABLE `table-name` CAN BE AFFECTED BY THE OPERATION