Work with PF Constraints (WRKPFCST)
| Where allowed to run: Interactive environments (*INTERACT *IPGM *IREXX *EXEC) Threadsafe: No |
Parameters Examples Error messages |
The Work with Physical File Constraints (WRKPFCST) command can be used to show a display from which you can change, remove, or display physical file constraints. You can work with specified types of constraint relationships that are defined for all physical files or a specified physical file.
| Top |
Parameters
| Keyword | Description | Choices | Notes |
|---|---|---|---|
| FILE | File | Qualified object name | Required, Positional 1 |
| Qualifier 1: File | Name, *ALL | ||
| Qualifier 2: Library | Name, *LIBL, *CURLIB, *ALL | ||
| TYPE | Constraint type | *ALL, *CHKCST, *CHKPND, *PRIKEY, *REFCST, *UNQCST | Optional, Positional 2 |
| Top |
File (FILE)
Specifies the physical file for which you are showing constraint relationships.
Qualifier 1: File
- *ALL
- All physical files that have constraint relationships are shown.
- name
- Specify the name of the physical file.
Qualifier 2: Library
- *LIBL
- All libraries in the library list for the current thread are searched. All objects in these libraries with the specified object name are shown.
- *CURLIB
- The current library for the job is searched. If no library is specified as the current library for the job, the QGPL library is used.
- *ALL
- All libraries on the system are searched.
- name
- Specify the name of the library to be searched.
| Top |
Constraint type (TYPE)
Specifies the type of constraint you are showing.
- *ALL
- All types of constraint relationships for the specified physical file are shown.
- *CHKCST
- The check constraints are shown.
- *REFCST
- The referential constraints are shown.
- *UNQCST
- The unique constraints are shown.
- *PRIKEY
- The primary key constraints are shown.
- *CHKPND
- The constraint relationships that have records that possibly are in violation of the constraints and are pending verification (check pending) are shown.
| Top |
Examples
WRKPFCST FILE(ADMN/PERSONNEL) TYPE(*CHKPND)
This command shows a list of the referential constraints that are in check pending status for the dependent file PERSONNEL located in the library ADMN.
| Top |
Error messages
*ESCAPE Messages
- CPF9809
- Library &1 cannot be accessed.
- CPF9810
- Library &1 not found.
- CPF9812
- File &1 in library &2 not found.
- CPF9820
- Not authorized to use library &1.
- CPF9822
- Not authorized to file &1 in library &2.
| Top |