| |
- Causa
- THE RELATIONSHIP constraint-name RESTRICTS THE DELETION OF ROW WITH RID X'rid-number'.
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.
- Ação do sistema
- The DELETE statement cannot be executed.
The contents of the object table are unchanged.
- Resposta ao Desenvolvedor
- 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
© Copyright IBM Corp.
|
| |
