Ansicht
Dokumentation

SQL0531 - Update prevented by referential constraint &1 in &2. ( OS/400 )

ROGBILLS - Synchronize billing plans   Fill RESBD Structure from EBP Component Structure  
This documentation is copyright by IBM.


Message : SQL0531
Update prevented by referential constraint &1 in &2.

Message Long Text :

Cause . . . . . : Constraint &1 in &2 identifies the table being updated as the parent table in a relationship with dependent table &3 in &4, with an update rule of RESTRICT or NO ACTION. The update of a parent key is prevented when there are rows in the dependent table with matching values.
Recovery . . . : In order to perform this update, you must either drop the constraint, or delete the rows in the dependent table that are dependent on this row.

Message File : QSQLMSG
Library Message File : QSYS2924


PERFORM Short Reference   SUBST_MERGE_LIST - merge external lists to one complete list with #if... logic for R3up  
This documentation is copyright by IBM.

Length: 3234 Date: 20240426 Time: 222240     sap01-206 ( 4 ms )