Display CHKPND Constraint (DSPCPCST)
| Where allowed to run: All environments (*ALL) Threadsafe: No |
Parameters Examples Error messages |
The Display Check Pending Constraint (DSPCPCST) command can be used to show the records that are possibly in violation of established constraints (check pending).
Restrictions:
- Only referential and check constraints that are disabled can be shown.
| Top |
Parameters
| Keyword | Description | Choices | Notes |
|---|---|---|---|
| FILE | File | Qualified object name | Required, Positional 1 |
| Qualifier 1: File | Name | ||
| Qualifier 2: Library | Name, *LIBL, *CURLIB | ||
| CST | Constraint name | Character value | Required, Positional 2 |
| OUTPUT | Output | Optional |
| Top |
File (FILE)
Specifies the dependent file on which the referential constraint is defined for a referential constraint, or the file for a check constraint.
This is a required parameter.
Qualifier 1: File
- name
- Specify the name of the physical file.
Qualifier 2: Library
- *LIBL
- All libraries in the library list for the current thread are searched until the first match is found.
- *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.
- name
- Specify the name of the library to be searched.
| Top |
Constraint name (CST)
Specifies the constraint that is defined for the file.
This is a required parameter.
- character-value
- Specify the name of the constraint.
| Top |
Output (OUTPUT)
Specifies whether the output from the command is shown at the requesting work station or printed with the job's spooled output.
- *
- The output requested by an interactive job is shown on the display. The output requested by a batch job is printed with the job's spooled output.
- The output is printed with the job's spooled output.
| Top |
Examples
DSPCPCST FILE(ADMN/PERSONNEL) CST(1994hires)
OUTPUT(*PRINT)
This command prints a list of records that are in check pending for the referential constraint named 1994hires on the dependent file PERSONNEL in the ADMN library.
| Top |
| Top |