200 lines
7.3 KiB
HTML
200 lines
7.3 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>Create Data Dictionary (CRTDTADCT)</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="CRTDTADCT.Top_Of_Page"></a>
|
|
<h2>Create Data Dictionary (CRTDTADCT)</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="#CRTDTADCT.PARAMETERS.TABLE">Parameters</a><br>
|
|
<a href="#CRTDTADCT.COMMAND.EXAMPLES">Examples</a><br>
|
|
<a href="#CRTDTADCT.ERROR.MESSAGES">Error messages</a></td>
|
|
</tr>
|
|
</table>
|
|
|
|
<div> <a name="CRTDTADCT"></a>
|
|
<p>The Create Data Dictionary (CRTDTADCT) command creates a data dictionary. A data dictionary must be created before the user can use the Interactive Data Definition Utility (IDDU) to describe and create database files. The user can create a data dictionary with IDDU or with the CRTDTADCT command. More information is in the IDDU Use book, SC41-5704.
|
|
</p>
|
|
</div>
|
|
<table width="100%">
|
|
<tr><td align="right"><a href="#CRTDTADCT.Top_Of_Page">Top</a></td></tr>
|
|
</table>
|
|
<hr size="2" width="100%">
|
|
|
|
<div>
|
|
<h3><a name="CRTDTADCT.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="#CRTDTADCT.DTADCT"><b>DTADCT</b></a></td>
|
|
<td valign="top">Data dictionary</td>
|
|
<td valign="top"><i>Name</i></td>
|
|
<td valign="top">Required, Positional 1</td>
|
|
</tr>
|
|
<tr>
|
|
<td valign="top"><a href="#CRTDTADCT.TEXT"><b>TEXT</b></a></td>
|
|
<td valign="top">Text 'description'</td>
|
|
<td valign="top"><i>Character value</i>, <b><u>*BLANK</u></b></td>
|
|
<td valign="top">Optional</td>
|
|
</tr>
|
|
<tr>
|
|
<td valign="top"><a href="#CRTDTADCT.AUT"><b>AUT</b></a></td>
|
|
<td valign="top">Authority</td>
|
|
<td valign="top"><i>Name</i>, <b><u>*LIBCRTAUT</u></b>, *CHANGE, *ALL, *USE, *EXCLUDE</td>
|
|
<td valign="top">Optional</td>
|
|
</tr>
|
|
</table>
|
|
|
|
<table width="100%">
|
|
<tr><td align="right"><a href="#CRTDTADCT.Top_Of_Page">Top</a></td></tr>
|
|
</table>
|
|
</div>
|
|
<div> <a name="CRTDTADCT.DTADCT"></a>
|
|
<h3>Data dictionary (DTADCT)</h3>
|
|
<p>Specifies the name that the data dictionary is assigned when it is created. The dictionary name must be the same as the library name where it is created. The library must already exist.
|
|
</p>
|
|
<p>This is a required parameter.
|
|
</p>
|
|
</div>
|
|
<table width="100%">
|
|
<tr><td align="right"><a href="#CRTDTADCT.Top_Of_Page">Top</a></td></tr>
|
|
</table>
|
|
<div> <a name="CRTDTADCT.TEXT"></a>
|
|
<h3>Text 'description' (TEXT)</h3>
|
|
<p>Specifies the text that briefly describes the object.
|
|
</p>
|
|
<p>The possible values are:
|
|
</p>
|
|
<dl>
|
|
<dt><b>*BLANK</b></dt>
|
|
<dd>No text is specified.
|
|
</dd>
|
|
<dt><b><i>'description'</i></b></dt>
|
|
<dd>Specify text no longer than 50 characters enclosed in apostrophes.
|
|
</dd>
|
|
</dl>
|
|
</div>
|
|
<table width="100%">
|
|
<tr><td align="right"><a href="#CRTDTADCT.Top_Of_Page">Top</a></td></tr>
|
|
</table>
|
|
<div> <a name="CRTDTADCT.AUT"></a>
|
|
<h3>Authority (AUT)</h3>
|
|
<p>Specifies the authority you are giving to users who do not have specific authority for the object, who are not on an authorization list, and whose group profile or supplemental group profiles do not have specific authority for the object.
|
|
</p>
|
|
<p>The possible values are:
|
|
</p>
|
|
<dl>
|
|
<dt><b><u>*LIBCRTAUT</u></b></dt>
|
|
<dd>The system determines the authority for the object by using the value specified on the <b>Create authority</b> prompt (CRTAUT parameter) on the Create Library command (CRTLIB) for the library containing the object to be created. If the value specified on the <b>Create authority</b> prompt (CRTAUT parameter) is changed, the new value will not affect any existing objects.
|
|
</dd>
|
|
</dl>
|
|
<dl>
|
|
<dt><b>*CHANGE</b></dt>
|
|
<dd>The user can perform all operations on the object except those limited to the owner or controlled by object existence (*OBJEXIST) and object management (*OBJMGT) authorities. The user can change and perform basic functions on the object. *CHANGE authority provides object operational (*OBJOPR) authority and all data authority. If the object is an authorization list, the user cannot add, change, or remove users.
|
|
</dd>
|
|
</dl>
|
|
<dl>
|
|
</dl>
|
|
<dl>
|
|
<dt><b>*ALL</b></dt>
|
|
<dd>The user can perform all operations except those limited to the owner or controlled by authorization list management (*AUTLMGT) authority. The user can control the object's existence, specify the security for the object, change the object, and perform basic functions on the object. The user also can change ownership of the object.
|
|
</dd>
|
|
</dl>
|
|
<dl>
|
|
</dl>
|
|
<dl>
|
|
<dt><b>*USE</b></dt>
|
|
<dd>The user can perform basic operations on the object, such as running a program or reading a file. The user cannot change the object. Use (*USE) authority provides object operational (*OBJOPR), read (*READ), and execute (*EXECUTE) authorities.
|
|
</dd>
|
|
</dl>
|
|
<dl>
|
|
</dl>
|
|
<dl>
|
|
<dt><b>*EXCLUDE</b></dt>
|
|
<dd>The user cannot access the object.
|
|
</dd>
|
|
</dl>
|
|
<dl>
|
|
<dt><b><i>authorization-list-name</i></b></dt>
|
|
<dd>Specify the name of an authorization list. Users included on the authorization list are granted authority to the object as specified by the list. The authorization list must exist when the object is created.
|
|
</dd>
|
|
</dl>
|
|
</div>
|
|
<table width="100%">
|
|
<tr><td align="right"><a href="#CRTDTADCT.Top_Of_Page">Top</a></td></tr>
|
|
</table>
|
|
<hr size="2" width="100%">
|
|
<div><h3><a name="CRTDTADCT.COMMAND.EXAMPLES">Examples</a> </h3>
|
|
<p><b>Example 1: Creating a Data Dictionary and Granting USE Authority</b>
|
|
</p>
|
|
<p>
|
|
<pre>
|
|
CRTDTADCT DTADCT(DEPT547) AUT(*USE)
|
|
TEXT('dept547 dictionary')
|
|
</pre>
|
|
</p>
|
|
<p>This command creates a data dictionary named DEPT547 in library DEPT547. The authority given for the dictionary to other users is *USE.
|
|
</p>
|
|
<p><b>Example 2: Creating a Restricted Data Dictionary</b>
|
|
</p>
|
|
<p>
|
|
<pre>
|
|
CRTDTADCT DTADCT(DEPT245) AUT(MYLIST)
|
|
TEXT('restricted dictionary')
|
|
</pre>
|
|
</p>
|
|
<p>This command creates a restricted data dictionary named DEPT245 in library DEPT245. The authority given for the dictionary to the users comes from the authorization list named MYLIST.
|
|
</p>
|
|
</div>
|
|
<table width="100%">
|
|
<tr><td align="right"><a href="#CRTDTADCT.Top_Of_Page">Top</a></td></tr>
|
|
</table>
|
|
<hr size="2" width="100%">
|
|
<div><h3><a name="CRTDTADCT.ERROR.MESSAGES">Error messages</a> </h3>
|
|
<p><b><u>*ESCAPE Messages</u></b>
|
|
</p>
|
|
<dl>
|
|
<dt><b>CPF2DAB</b></dt>
|
|
<dd>Authority list &1 not found
|
|
</dd>
|
|
<dt><b>CPF2D71</b></dt>
|
|
<dd>Dictionary name cannot be &1.
|
|
</dd>
|
|
<dt><b>CPF2F04</b></dt>
|
|
<dd>Dictionary &1 already exists.
|
|
</dd>
|
|
<dt><b>CPF2F07</b></dt>
|
|
<dd>Dictionary &1 in error.
|
|
</dd>
|
|
<dt><b>CPF2F11</b></dt>
|
|
<dd>Dictionary &1 not created.
|
|
</dd>
|
|
<dt><b>CPF9820</b></dt>
|
|
<dd>Not authorized to use library &1.
|
|
</dd>
|
|
<dt><b>CPF9830</b></dt>
|
|
<dd>Cannot assign library &1.
|
|
</dd>
|
|
</dl>
|
|
</div>
|
|
<table width="100%">
|
|
<tr><td align="right"><a href="#CRTDTADCT.Top_Of_Page">Top</a></td></tr>
|
|
</table>
|
|
</body>
|
|
</html>
|