171 lines
5.4 KiB
HTML
171 lines
5.4 KiB
HTML
|
|
||
|
|
<!doctype html PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN">
|
||
|
|
<html>
|
||
|
|
<head><META http-equiv="Content-Type" content="text/html; charset=utf-8">
|
||
|
|
<title>Work with PF Constraints (WRKPFCST)</title>
|
||
|
|
<link rel="stylesheet" type="text/css" href="../rzahg/ic.css">
|
||
|
|
</head>
|
||
|
|
<body bgcolor="white">
|
||
|
|
<script language="Javascript" src="../rzahg/synch.js" type="text/javascript"></script>
|
||
|
|
<a name="WRKPFCST.Top_Of_Page"></a>
|
||
|
|
<h2>Work with PF Constraints (WRKPFCST)</h2>
|
||
|
|
<table width="100%">
|
||
|
|
<tr>
|
||
|
|
<td valign="top" align="left"><b>Where allowed to run: </b>Interactive environments (*INTERACT *IPGM *IREXX *EXEC)<br>
|
||
|
|
<b>Threadsafe: </b>No
|
||
|
|
</td>
|
||
|
|
<td valign="top" align="right">
|
||
|
|
<a href="#WRKPFCST.PARAMETERS.TABLE">Parameters</a><br>
|
||
|
|
<a href="#WRKPFCST.COMMAND.EXAMPLES">Examples</a><br>
|
||
|
|
<a href="#WRKPFCST.ERROR.MESSAGES">Error messages</a></td>
|
||
|
|
</tr>
|
||
|
|
</table>
|
||
|
|
|
||
|
|
<div> <a name="WRKPFCST"></a>
|
||
|
|
<p>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.
|
||
|
|
</p>
|
||
|
|
</div>
|
||
|
|
<table width="100%">
|
||
|
|
<tr><td align="right"><a href="#WRKPFCST.Top_Of_Page">Top</a></td></tr>
|
||
|
|
</table>
|
||
|
|
<hr size="2" width="100%">
|
||
|
|
|
||
|
|
<div>
|
||
|
|
<h3><a name="WRKPFCST.PARAMETERS.TABLE">Parameters</a></h3>
|
||
|
|
<table border="1" cellpadding="4" cellspacing="0">
|
||
|
|
<!-- col1="10" col2="15" col3="30" col4="10" -->
|
||
|
|
<tr>
|
||
|
|
<th bgcolor="aqua" valign="bottom" align="left">Keyword</th>
|
||
|
|
<th bgcolor="aqua" valign="bottom" align="left">Description</th>
|
||
|
|
<th bgcolor="aqua" valign="bottom" align="left">Choices</th>
|
||
|
|
<th bgcolor="aqua" valign="bottom" align="left">Notes</th>
|
||
|
|
</tr>
|
||
|
|
<tr>
|
||
|
|
<td valign="top" rowspan="3"><a href="#WRKPFCST.FILE"><b>FILE</b></a></td>
|
||
|
|
<td valign="top">File</td>
|
||
|
|
<td valign="top"><i>Qualified object name</i></td>
|
||
|
|
<td valign="top" rowspan="3">Required, Positional 1</td>
|
||
|
|
</tr>
|
||
|
|
<tr>
|
||
|
|
<td valign="top">Qualifier 1: File</td>
|
||
|
|
<td valign="top"><i>Name</i>, *ALL</td>
|
||
|
|
</tr><tr>
|
||
|
|
<td valign="top">Qualifier 2: Library</td>
|
||
|
|
<td valign="top"><i>Name</i>, <b><u>*LIBL</u></b>, *CURLIB, *ALL</td>
|
||
|
|
</tr><tr>
|
||
|
|
<td valign="top"><a href="#WRKPFCST.TYPE"><b>TYPE</b></a></td>
|
||
|
|
<td valign="top">Constraint type</td>
|
||
|
|
<td valign="top"><b><u>*ALL</u></b>, *CHKCST, *CHKPND, *PRIKEY, *REFCST, *UNQCST</td>
|
||
|
|
<td valign="top">Optional, Positional 2</td>
|
||
|
|
</tr>
|
||
|
|
</table>
|
||
|
|
|
||
|
|
<table width="100%">
|
||
|
|
<tr><td align="right"><a href="#WRKPFCST.Top_Of_Page">Top</a></td></tr>
|
||
|
|
</table>
|
||
|
|
</div>
|
||
|
|
<div> <a name="WRKPFCST.FILE"></a>
|
||
|
|
<h3>File (FILE)</h3>
|
||
|
|
<p>Specifies the physical file for which you are showing constraint relationships.
|
||
|
|
</p>
|
||
|
|
<p><b>Qualifier 1: File</b>
|
||
|
|
</p>
|
||
|
|
<dl>
|
||
|
|
<dt><b><u>*ALL</u></b></dt>
|
||
|
|
<dd>All physical files that have constraint relationships are shown.
|
||
|
|
</dd>
|
||
|
|
<dt><b><i>name</i></b></dt>
|
||
|
|
<dd>Specify the name of the physical file.
|
||
|
|
</dd>
|
||
|
|
</dl>
|
||
|
|
<p><b>Qualifier 2: Library</b>
|
||
|
|
</p>
|
||
|
|
<dl>
|
||
|
|
<dt><b><u>*LIBL</u></b></dt>
|
||
|
|
<dd>All libraries in the library list for the current thread are searched. All objects in these libraries with the specified object name are shown.
|
||
|
|
</dd>
|
||
|
|
</dl>
|
||
|
|
<dl>
|
||
|
|
<dt><b>*CURLIB</b></dt>
|
||
|
|
<dd>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.
|
||
|
|
</dd>
|
||
|
|
<dt><b>*ALL</b></dt>
|
||
|
|
<dd>All libraries on the system are searched.
|
||
|
|
</dd>
|
||
|
|
<dt><b><i>name</i></b></dt>
|
||
|
|
<dd>Specify the name of the library to be searched.
|
||
|
|
</dd>
|
||
|
|
</dl>
|
||
|
|
</div>
|
||
|
|
<table width="100%">
|
||
|
|
<tr><td align="right"><a href="#WRKPFCST.Top_Of_Page">Top</a></td></tr>
|
||
|
|
</table>
|
||
|
|
<div> <a name="WRKPFCST.TYPE"></a>
|
||
|
|
<h3>Constraint type (TYPE)</h3>
|
||
|
|
<p>Specifies the type of constraint you are showing.
|
||
|
|
</p>
|
||
|
|
<dl>
|
||
|
|
<dt><b><u>*ALL</u></b></dt>
|
||
|
|
<dd>All types of constraint relationships for the specified physical file are shown.
|
||
|
|
</dd>
|
||
|
|
<dt><b>*CHKCST</b></dt>
|
||
|
|
<dd>The check constraints are shown.
|
||
|
|
</dd>
|
||
|
|
<dt><b>*REFCST</b></dt>
|
||
|
|
<dd>The referential constraints are shown.
|
||
|
|
</dd>
|
||
|
|
<dt><b>*UNQCST</b></dt>
|
||
|
|
<dd>The unique constraints are shown.
|
||
|
|
</dd>
|
||
|
|
<dt><b>*PRIKEY</b></dt>
|
||
|
|
<dd>The primary key constraints are shown.
|
||
|
|
</dd>
|
||
|
|
<dt><b>*CHKPND</b></dt>
|
||
|
|
<dd>The constraint relationships that have records that possibly are in violation of the constraints and are pending verification (check pending) are shown.
|
||
|
|
</dd>
|
||
|
|
</dl>
|
||
|
|
</div>
|
||
|
|
<table width="100%">
|
||
|
|
<tr><td align="right"><a href="#WRKPFCST.Top_Of_Page">Top</a></td></tr>
|
||
|
|
</table>
|
||
|
|
<hr size="2" width="100%">
|
||
|
|
<div><h3><a name="WRKPFCST.COMMAND.EXAMPLES">Examples</a> </h3>
|
||
|
|
<p>
|
||
|
|
<pre>
|
||
|
|
WRKPFCST FILE(ADMN/PERSONNEL) TYPE(*CHKPND)
|
||
|
|
</pre>
|
||
|
|
</p>
|
||
|
|
<p>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.
|
||
|
|
</p>
|
||
|
|
</div>
|
||
|
|
<table width="100%">
|
||
|
|
<tr><td align="right"><a href="#WRKPFCST.Top_Of_Page">Top</a></td></tr>
|
||
|
|
</table>
|
||
|
|
<hr size="2" width="100%">
|
||
|
|
<div><h3><a name="WRKPFCST.ERROR.MESSAGES">Error messages</a> </h3>
|
||
|
|
<p><b><u>*ESCAPE Messages</u></b>
|
||
|
|
</p>
|
||
|
|
<dl>
|
||
|
|
<dt><b>CPF9809</b></dt>
|
||
|
|
<dd>Library &1 cannot be accessed.
|
||
|
|
</dd>
|
||
|
|
<dt><b>CPF9810</b></dt>
|
||
|
|
<dd>Library &1 not found.
|
||
|
|
</dd>
|
||
|
|
<dt><b>CPF9812</b></dt>
|
||
|
|
<dd>File &1 in library &2 not found.
|
||
|
|
</dd>
|
||
|
|
<dt><b>CPF9820</b></dt>
|
||
|
|
<dd>Not authorized to use library &1.
|
||
|
|
</dd>
|
||
|
|
<dt><b>CPF9822</b></dt>
|
||
|
|
<dd>Not authorized to file &1 in library &2.
|
||
|
|
</dd>
|
||
|
|
</dl>
|
||
|
|
</div>
|
||
|
|
<table width="100%">
|
||
|
|
<tr><td align="right"><a href="#WRKPFCST.Top_Of_Page">Top</a></td></tr>
|
||
|
|
</table>
|
||
|
|
</body>
|
||
|
|
</html>
|