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.

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.

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.

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.

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.