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.

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	*, *PRINT	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.

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.

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.

*PRINT

The output is printed with the job's spooled output.

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.

Error messages

None

*ESCAPE Messages

CPF32B6

Constraint cannot be displayed for file &1.