291 lines
9.4 KiB
HTML
291 lines
9.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>Link/Unlink Data Definition (LNKDTADFN)</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="LNKDTADFN.Top_Of_Page"></a>
|
||
|
|
<h2>Link/Unlink Data Definition (LNKDTADFN)</h2>
|
||
|
|
<table width="100%">
|
||
|
|
<tr>
|
||
|
|
<td valign="top" align="left"><b>Where allowed to run: </b>All environments (*ALL)<br>
|
||
|
|
<b>Threadsafe: </b>No
|
||
|
|
</td>
|
||
|
|
<td valign="top" align="right">
|
||
|
|
<a href="#LNKDTADFN.PARAMETERS.TABLE">Parameters</a><br>
|
||
|
|
<a href="#LNKDTADFN.COMMAND.EXAMPLES">Examples</a><br>
|
||
|
|
<a href="#LNKDTADFN.ERROR.MESSAGES">Error messages</a></td>
|
||
|
|
</tr>
|
||
|
|
</table>
|
||
|
|
|
||
|
|
<div> <a name="LNKDTADFN"></a>
|
||
|
|
<p>The Link Data Definition (LNKDTADFN) command links or unlinks file definitions in a dictionary, program-described files, or externally-described files.
|
||
|
|
</p>
|
||
|
|
<p><b>Restriction:</b> A file cannot be linked if it is already linked. However, a definition can be linked to several files at the same time.
|
||
|
|
</p>
|
||
|
|
<p>
|
||
|
|
<b>Note: </b>If file text and the file definition are not the same, a new version of the definition is created.
|
||
|
|
</p>
|
||
|
|
</div>
|
||
|
|
<table width="100%">
|
||
|
|
<tr><td align="right"><a href="#LNKDTADFN.Top_Of_Page">Top</a></td></tr>
|
||
|
|
</table>
|
||
|
|
<hr size="2" width="100%">
|
||
|
|
|
||
|
|
<div>
|
||
|
|
<h3><a name="LNKDTADFN.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"><a href="#LNKDTADFN.OPTION"><b>OPTION</b></a></td>
|
||
|
|
<td valign="top">Option</td>
|
||
|
|
<td valign="top">*LINK, *UNLINK</td>
|
||
|
|
<td valign="top">Required, Positional 1</td>
|
||
|
|
</tr>
|
||
|
|
<tr>
|
||
|
|
<td valign="top" rowspan="3"><a href="#LNKDTADFN.FILE"><b>FILE</b></a></td>
|
||
|
|
<td valign="top">Data base file</td>
|
||
|
|
<td valign="top">Single values: *ALL<br>Other values: <i>Qualified object name</i></td>
|
||
|
|
<td valign="top" rowspan="3">Required, Positional 2</td>
|
||
|
|
</tr>
|
||
|
|
<tr>
|
||
|
|
<td valign="top">Qualifier 1: Data base file</td>
|
||
|
|
<td valign="top"><i>Name</i></td>
|
||
|
|
</tr><tr>
|
||
|
|
<td valign="top">Qualifier 2: Library</td>
|
||
|
|
<td valign="top"><i>Name</i>, <b><u>*LIBL</u></b>, *CURLIB</td>
|
||
|
|
</tr><tr>
|
||
|
|
<td valign="top"><a href="#LNKDTADFN.DTADCT"><b>DTADCT</b></a></td>
|
||
|
|
<td valign="top">Data dictionary</td>
|
||
|
|
<td valign="top"><i>Name</i></td>
|
||
|
|
<td valign="top">Optional</td>
|
||
|
|
</tr>
|
||
|
|
<tr>
|
||
|
|
<td valign="top"><a href="#LNKDTADFN.DFN"><b>DFN</b></a></td>
|
||
|
|
<td valign="top">File definition</td>
|
||
|
|
<td valign="top"><i>Name</i></td>
|
||
|
|
<td valign="top">Optional</td>
|
||
|
|
</tr>
|
||
|
|
<tr>
|
||
|
|
<td valign="top"><a href="#LNKDTADFN.CRTDATE"><b>CRTDATE</b></a></td>
|
||
|
|
<td valign="top">Creation date</td>
|
||
|
|
<td valign="top"><i>Date</i>, <b><u>*FIRST</u></b></td>
|
||
|
|
<td valign="top">Optional</td>
|
||
|
|
</tr>
|
||
|
|
</table>
|
||
|
|
|
||
|
|
<table width="100%">
|
||
|
|
<tr><td align="right"><a href="#LNKDTADFN.Top_Of_Page">Top</a></td></tr>
|
||
|
|
</table>
|
||
|
|
</div>
|
||
|
|
<div> <a name="LNKDTADFN.OPTION"></a>
|
||
|
|
<h3>Option (OPTION)</h3>
|
||
|
|
<p>Specifies the action that is performed on the program-described file, externally-described file, or file definition.
|
||
|
|
</p>
|
||
|
|
<p>
|
||
|
|
<b>Note: </b>Externally-described files can only be unlinked.
|
||
|
|
</p>
|
||
|
|
<p>This is a required parameter.
|
||
|
|
</p>
|
||
|
|
<p>The possible values are:
|
||
|
|
</p>
|
||
|
|
<dl>
|
||
|
|
<dt><b>*LINK</b></dt>
|
||
|
|
<dd>The program-described file or file definition is linked.
|
||
|
|
</dd>
|
||
|
|
<dt><b>*UNLINK</b></dt>
|
||
|
|
<dd>The program-described file, externally-described file, or the file definition is unlinked.
|
||
|
|
</dd>
|
||
|
|
</dl>
|
||
|
|
</div>
|
||
|
|
<table width="100%">
|
||
|
|
<tr><td align="right"><a href="#LNKDTADFN.Top_Of_Page">Top</a></td></tr>
|
||
|
|
</table>
|
||
|
|
<div> <a name="LNKDTADFN.FILE"></a>
|
||
|
|
<h3>Data base file (FILE)</h3>
|
||
|
|
<p>Specifies the name and library of the program-described file or externally-described file to be linked or unlinked.
|
||
|
|
</p>
|
||
|
|
<p>This is a required parameter.
|
||
|
|
</p>
|
||
|
|
<p>The possible file values are:
|
||
|
|
</p>
|
||
|
|
<dl>
|
||
|
|
<dt><b>*ALL</b></dt>
|
||
|
|
<dd>All program-described files linked to definitions in the specified dictionary are unlinked. This value is valid only if *UNLINK is also specified for the <b>Option</b> prompt (OPTION parameter) and a dictionary name is also specified for the <b>Data dictionary</b> prompt (DTADCT parameter). This value is not valid for externally-described files.
|
||
|
|
</dd>
|
||
|
|
<dt><b><i>library-name/file-name</i></b></dt>
|
||
|
|
<dd>Specify the name of the database file being linked or unlinked.
|
||
|
|
</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 until the first match is found.
|
||
|
|
</dd>
|
||
|
|
</dl>
|
||
|
|
<dl>
|
||
|
|
<dt><b>*CURLIB</b></dt>
|
||
|
|
<dd>The current library for the thread is used to locate the file. If no library is specified as the current library for the job, the QGPL library is used.
|
||
|
|
</dd>
|
||
|
|
</dl>
|
||
|
|
<dl>
|
||
|
|
<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="#LNKDTADFN.Top_Of_Page">Top</a></td></tr>
|
||
|
|
</table>
|
||
|
|
<div> <a name="LNKDTADFN.DTADCT"></a>
|
||
|
|
<h3>Data dictionary (DTADCT)</h3>
|
||
|
|
<p>Specifies the name of the dictionary that contains the file definition being linked or unlinked to the program-described file. A name is required if *LINK is specified for the <b>Option</b> prompt (OPTION parameter), or if *ALL is specified for the <b>Data base file</b> prompt (FILE parameter) and *UNLINK is specified for the <b>Option</b> prompt (OPTION parameter).
|
||
|
|
</p>
|
||
|
|
</div>
|
||
|
|
<table width="100%">
|
||
|
|
<tr><td align="right"><a href="#LNKDTADFN.Top_Of_Page">Top</a></td></tr>
|
||
|
|
</table>
|
||
|
|
<div> <a name="LNKDTADFN.DFN"></a>
|
||
|
|
<h3>File definition (DFN)</h3>
|
||
|
|
<p>Specifies the name of the file definition being linked to the program-described file. This parameter is not applicable if *UNLINK is specified for the <b>Option</b> prompt (OPTION parameter).
|
||
|
|
</p>
|
||
|
|
</div>
|
||
|
|
<table width="100%">
|
||
|
|
<tr><td align="right"><a href="#LNKDTADFN.Top_Of_Page">Top</a></td></tr>
|
||
|
|
</table>
|
||
|
|
<div> <a name="LNKDTADFN.CRTDATE"></a>
|
||
|
|
<h3>Creation date (CRTDATE)</h3>
|
||
|
|
<p>Specifies the creation date of the file definition being linked to the program-described file. This information is ignored if *UNLINK is specified for the <b>Option</b> prompt (OPTION parameter).
|
||
|
|
</p>
|
||
|
|
<p>The possible values are:
|
||
|
|
</p>
|
||
|
|
<dl>
|
||
|
|
<dt><b>*FIRST</b></dt>
|
||
|
|
<dd>The file definition with the specified definition name and the earliest creation date is used.
|
||
|
|
</dd>
|
||
|
|
<dt><b><i>creation-date</i></b></dt>
|
||
|
|
<dd>Specify the creation date of the file definition being linked to the program-described file.
|
||
|
|
</dd>
|
||
|
|
</dl>
|
||
|
|
</div>
|
||
|
|
<table width="100%">
|
||
|
|
<tr><td align="right"><a href="#LNKDTADFN.Top_Of_Page">Top</a></td></tr>
|
||
|
|
</table>
|
||
|
|
<hr size="2" width="100%">
|
||
|
|
<div><h3><a name="LNKDTADFN.COMMAND.EXAMPLES">Examples</a> </h3>
|
||
|
|
<p>
|
||
|
|
<pre>
|
||
|
|
LNKDTADFN OPTION(*LINK) FILE(MYLIB/MYFILE)
|
||
|
|
DTADCT(MINE) DFN(MYDEF)
|
||
|
|
</pre>
|
||
|
|
</p>
|
||
|
|
<p>This command links definition MYDEF in dictionary MINE, to the program-described database file MYFILE located in library MYLIB.
|
||
|
|
</p>
|
||
|
|
</div>
|
||
|
|
<table width="100%">
|
||
|
|
<tr><td align="right"><a href="#LNKDTADFN.Top_Of_Page">Top</a></td></tr>
|
||
|
|
</table>
|
||
|
|
<hr size="2" width="100%">
|
||
|
|
<div><h3><a name="LNKDTADFN.ERROR.MESSAGES">Error messages</a> </h3>
|
||
|
|
<p><b><u>*ESCAPE Messages</u></b>
|
||
|
|
</p>
|
||
|
|
<dl>
|
||
|
|
<dt><b>CPF2E9B</b></dt>
|
||
|
|
<dd>Definition &1 not found.
|
||
|
|
</dd>
|
||
|
|
<dt><b>CPF2FE0</b></dt>
|
||
|
|
<dd>Error occurred while opening dictionary &1.
|
||
|
|
</dd>
|
||
|
|
<dt><b>CPF2FE1</b></dt>
|
||
|
|
<dd>Error occurred while closing dictionary &1.
|
||
|
|
</dd>
|
||
|
|
<dt><b>CPF2FE2</b></dt>
|
||
|
|
<dd>Dictionary &1 currently in use.
|
||
|
|
</dd>
|
||
|
|
<dt><b>CPF2FE3</b></dt>
|
||
|
|
<dd>System cross reference file is in error.
|
||
|
|
</dd>
|
||
|
|
<dt><b>CPF2FE4</b></dt>
|
||
|
|
<dd>System cross reference file not available.
|
||
|
|
</dd>
|
||
|
|
<dt><b>CPF2F02</b></dt>
|
||
|
|
<dd>Not authorized to use dictionary &1.
|
||
|
|
</dd>
|
||
|
|
<dt><b>CPF2F07</b></dt>
|
||
|
|
<dd>Dictionary &1 in error.
|
||
|
|
</dd>
|
||
|
|
<dt><b>CPF2F08</b></dt>
|
||
|
|
<dd>Dictionary &1 not found.
|
||
|
|
</dd>
|
||
|
|
<dt><b>CPF2F6A</b></dt>
|
||
|
|
<dd>File &2 in &3 not valid for LNKDTADFN.
|
||
|
|
</dd>
|
||
|
|
<dt><b>CPF2F6C</b></dt>
|
||
|
|
<dd>All files were not unlinked.
|
||
|
|
</dd>
|
||
|
|
<dt><b>CPF2F61</b></dt>
|
||
|
|
<dd>File &2 in &3 currently in use.
|
||
|
|
</dd>
|
||
|
|
<dt><b>CPF2F7B</b></dt>
|
||
|
|
<dd>File &2 not linked. Record lengths not equal.
|
||
|
|
</dd>
|
||
|
|
<dt><b>CPF2F7C</b></dt>
|
||
|
|
<dd>Start key position &1 splits field &2.
|
||
|
|
</dd>
|
||
|
|
<dt><b>CPF2F7D</b></dt>
|
||
|
|
<dd>End key position &1 splits field &2.
|
||
|
|
</dd>
|
||
|
|
<dt><b>CPF2F7F</b></dt>
|
||
|
|
<dd>File &2 in &3 is already linked.
|
||
|
|
</dd>
|
||
|
|
<dt><b>CPF2F76</b></dt>
|
||
|
|
<dd>Only file definitions for physical files can be linked.
|
||
|
|
</dd>
|
||
|
|
<dt><b>CPF2F77</b></dt>
|
||
|
|
<dd>File not keyed. Cannot link to keyed file definition.
|
||
|
|
</dd>
|
||
|
|
<dt><b>CPF2F78</b></dt>
|
||
|
|
<dd>Definition &1 in error.
|
||
|
|
</dd>
|
||
|
|
<dt><b>CPF2F79</b></dt>
|
||
|
|
<dd>Key fields do not match.
|
||
|
|
</dd>
|
||
|
|
<dt><b>CPF2F80</b></dt>
|
||
|
|
<dd>File &2 in &3 is not linked.
|
||
|
|
</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>
|
||
|
|
<dt><b>CPF9845</b></dt>
|
||
|
|
<dd>Error occurred while opening file &1.
|
||
|
|
</dd>
|
||
|
|
<dt><b>CPF9846</b></dt>
|
||
|
|
<dd>Error while processing file &1 in library &2.
|
||
|
|
</dd>
|
||
|
|
<dt><b>CPF9847</b></dt>
|
||
|
|
<dd>Error occurred while closing file &1 in library &2.
|
||
|
|
</dd>
|
||
|
|
</dl>
|
||
|
|
</div>
|
||
|
|
<table width="100%">
|
||
|
|
<tr><td align="right"><a href="#LNKDTADFN.Top_Of_Page">Top</a></td></tr>
|
||
|
|
</table>
|
||
|
|
</body>
|
||
|
|
</html>
|