DSPCPCST (Display Check Pending Constraint) Command Description

DSPCPCST Command syntax diagram

Purpose

The Display Check Pending Constraint (DSPCPCST) command can be used to show the records that are possibly in violation of established referential constraints (check pending).

Restrictions: Only referential constraints that are disabled can be shown.

Required Parameters

FILE

Specifies the dependent file on which the referential constraint is defined.

The name of the physical file can be qualified by one of the following library values:

*LIBL: All libraries in the job's library list 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.

library-name: Specify the name of the library to be searched.

physical-file: Specify the name of the physical file.

CST

Specifies the name of the constraint relationship that is defined for the dependent file.

OUTPUT

Specifies whether the output from the command is shown at the requesting workstation or printed with the job's spooled output. More information on this parameter is in commonly used parameters.

*: 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.

*PRINT: The output is printed with the job's spooled output.

Example for DSPCPCST

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.

Error messages for DSPCPCST

None

*ESCAPE Messages

CPF32B6

Constraint cannot be displayed for file &1.