Ansicht
Dokumentation

CPD32C5 - Key values for referential constraint are not valid. ( OS/400 )

Fill RESBD Structure from EBP Component Structure   SUBST_MERGE_LIST - merge external lists to one complete list with #if... logic for R3up  
This documentation is copyright by IBM.


Message : CPD32C5
Key values for referential constraint are not valid.

Message Long Text :

Cause . . . . . : Referential constraint &13 for dependent file &1 in library &2 is in check pending. Parent file &5 in library &6 has a delete rule of &11 and update rule of &12.
The constraint is in check pending because record &8 in the dependent file has a foreign key value that does not match the parent key value in the parent file for record &9.
If the record number for the parent file or dependent file is 0, then the record either cannot be identified or does not apply to the check pending status.
Recovery . . . :
Use the CHGPFCST command for the dependent file to disable the constraint.
Use the DSPCPCST command for the dependent file to display the records that are causing the constraint to be in check pending.
Update the parent file and dependent file to make sure each foreign key entry in the dependent file has a corresponding parent key entry in the parent file.
Use the CHGPFCST command for the dependent file to enable the constraint. If there are not any foreign key - parent key mismatches, then the referential constraint will not be in check pending.

Message File : QCPFMSG
Library Message File : QSYS2924


Fill RESBD Structure from EBP Component Structure   General Data in Customer Master  
This documentation is copyright by IBM.

Length: 3246 Date: 20240418 Time: 165609     sap01-206 ( 2 ms )