Ansicht
Dokumentation

CPF3134 - Referential constraint error processing member &2. ( OS/400 )

General Data in Customer Master   ROGBILLS - Synchronize billing plans  
This documentation is copyright by IBM.


Message : CPF3134
Referential constraint error processing member &2.

Message Long Text :

Cause . . . . . : The operation being performed on member &2 file &1 in library &3 failed because of reason code &4. The reason codes and their meanings are:
1 -- A clear operation was requested and the file is a parent file with established and enabled referential constraints.
2 -- The file specified on the TOFILE parameter is a dependent file with established and enabled referential constraints.
3 -- Referential constraint &11 prevented the initialization of a default record in member &6 of dependent file &5 in library &7 because a matching key value was not found in member &9 of parent file &8 in library &10.
4 -- A copy operation was requested and the file is a dependent file with established and enabled referential constraints. Data cannot be copied into this file because matching key values may not be found in the parent file.
5 -- Referential constraint &11 for dependent file &5 in library &7 and parent file &8 in library &10 is in check pending status.
Recovery . . . :
1 -- Find the dependent files of the referential constraints using the DSPDBR command on parent file &1 in library &3. Disable the referential constraints using the CHGPFCST command or WRKPFCST command on the dependent files. After the clear operation has completed, use the CHGPFCST command or WRKPFCST command on the dependent files to enable the referential constraints.
2 -- Disable the referential constraints using the CHGPFCST command or WRKPFCST command on the dependent file. After the copy operation has completed, use the CHGPFCST command or WRKPFCST command on the dependent files to enable the referential constraints.
3 -- Specify the RECORDS(*DLT) parameter to initialize the member with deleted records or disable the referential constraint using the CHGPFCST command. After the initialization has completed, use the CHGPFCST command to enable the referential constraints.
4 -- Disable the referential constraints using the CHGPFCST command or WRKPFCST command. After the copy operation has completed, use the CHGPFCST command or WRKPFCST command to enable the referential constraints.
5 -- Disable the referential constraint on the dependent file using the CHGPFCST command. After the failing operation has completed, use the CHGPFCST command to enable the referential constraint.

Message File : QCPFMSG
Library Message File : QSYS2924


PERFORM Short Reference   ROGBILLS - Synchronize billing plans  
This documentation is copyright by IBM.

Length: 3252 Date: 20240427 Time: 025630     sap01-206 ( 3 ms )