| |
- Causa
- THE DELETE STATEMENT IS INVALID BECAUSE TABLE table-name CAN BE AFFECTED BY THE OPERATION.
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.
- Ação do sistema
- The DELETE statement cannot be processed.
The contents of the object table are unchanged.
- Resposta ao Desenvolvedor
- 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
© Copyright IBM Corp.
|
| |
