Ansicht
Dokumentation

SQL0971 - Constraint &4 in check pending state. ( OS/400 )

General Material Data   CPI1466 during Backup  
This documentation is copyright by IBM.


Message : SQL0971
Constraint &4 in check pending state.

Message Long Text :

Cause . . . . . : The operation being performed on table &2 in &3 failed. Constraint &4 in &5 could not be enforced because of reason code &1. The reason codes and their meanings are:
1 -- The dependent file is in check pending status due to a referential constraint violation.
2 -- The dependent or parent file's access path is not valid.
3 -- The file is in check pending status due to a check constraint violation.
Recovery . . . : For reason codes 1 and 3, use the CHGPFCST command to disable the constraint. Then use the DSPCPCST command to see the records causing the check pending status. Correct the data in the file and then use the CHGPFCST command to enable the constraint. For reason code 2, use the EDTRBDAP command or Manage Index Rebuilds in System i Navigator to rebuild the file's access path.

Message File : QSQLMSG
Library Message File : QSYS2924


BAL Application Log Documentation   BAL_S_LOG - Application Log: Log header data  
This documentation is copyright by IBM.

Length: 3225 Date: 20240426 Time: 043516     sap01-206 ( 3 ms )