Ansicht
Dokumentation

CPD32B1 - Constraint cannot be removed from file &1. ( OS/400 )

CPD32B1 - Constraint cannot be removed from file &1. ( OS/400 )

Addresses (Business Address Services)   SUBST_MERGE_LIST - merge external lists to one complete list with #if... logic for R3up  
This documentation is copyright by IBM.
SAP E-Book


Message : CPD32B1
Constraint cannot be removed from file &1.

Message Long Text :

Cause . . . . . : Constraint &7 cannot be removed from file &1 in library &2 for TYPE value &4, RMVCST value &5. The constraint was not removed because of errors. The reason code is &6. The reason codes and their meanings are as follows:
01 - CST(*CHKPND) and TYPE(*UNQCST) or TYPE(*PRIKEY) not valid.
02 - TYPE value not valid.
03 - RMVCST value not valid.
04 - Error locking file &8 or library &9 which is necessary to remove the constraint.
05 - File is logically damaged.
06 - Constraint name is not valid.
07 - Constraint not defined.
08 - Constraint type does not match TYPE specified.
09 - Primary key does not exist.
10 - *RESTRICT specified when removing referential constraints whose parent is a unique or primary key constraint.
11 - Error with QADBFCST cross reference file.
12 - File has no constraints.
13 - Check constraint associated with the primary key cannot be removed without removing the primary key.
14 - Unique constraint associated with a ROWID column cannot be removed.
Recovery . . . : Do one of the following based on the reason code shown, and then try the function again.
01 - Correct TYPE or CST and try the function again.
02 - Correct the TYPE value and try the function again.
03 - Correct the RMVCST value and try the function again.
04 - Release the locks on the object and try the function again.
05 - Delete the file and create it again.
06 - Correct the constraint name and try the function again.
07 - Correct the constraint name and try the function again.
08 - Correct the constraint name or TYPE value and try the function again.
09 - Correct the constraint name or TYPE and try the function again.
10 - Correct the RMVCST value and try the function again.
11 - Run reclaim storage (RCLSTG) and try the function again.
12 - Add constraints to the file or correct the file name and try the function again.
13 - When the primary key is removed, the associated check constraint will be removed.
14 - Correct the constraint name and try the function again.

Message File : QCPFMSG
Library Message File : QSYS2924


SUBST_MERGE_LIST - merge external lists to one complete list with #if... logic for R3up   CL_GUI_FRONTEND_SERVICES - Frontend Services  
This documentation is copyright by IBM.

Length: 3280 Date: 20240329 Time: 004254     sap01-206 ( 2 ms )