Create Data Dictionary (CRTDTADCT)

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.

Parameters

Keyword Description Choices Notes
DTADCT Data dictionary Name Required, Positional 1
TEXT Text 'description' Character value, *BLANK Optional
AUT Authority Name, *LIBCRTAUT, *CHANGE, *ALL, *USE, *EXCLUDE Optional

Data dictionary (DTADCT)

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.

This is a required parameter.

Text 'description' (TEXT)

Specifies the text that briefly describes the object.

The possible values are:

*BLANK
No text is specified.
'description'
Specify text no longer than 50 characters enclosed in apostrophes.

Authority (AUT)

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.

The possible values are:

*LIBCRTAUT
The system determines the authority for the object by using the value specified on the Create authority prompt (CRTAUT parameter) on the Create Library command (CRTLIB) for the library containing the object to be created. If the value specified on the Create authority prompt (CRTAUT parameter) is changed, the new value will not affect any existing objects.
*CHANGE
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.
*ALL
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.
*USE
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.
*EXCLUDE
The user cannot access the object.
authorization-list-name
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.

Examples

Example 1: Creating a Data Dictionary and Granting USE Authority

CRTDTADCT   DTADCT(DEPT547)  AUT(*USE)
            TEXT('dept547 dictionary')

This command creates a data dictionary named DEPT547 in library DEPT547. The authority given for the dictionary to other users is *USE.

Example 2: Creating a Restricted Data Dictionary

CRTDTADCT   DTADCT(DEPT245)  AUT(MYLIST)
            TEXT('restricted dictionary')

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.

Error messages

*ESCAPE Messages

CPF2DAB
Authority list &1 not found
CPF2D71
Dictionary name cannot be &1.
CPF2F04
Dictionary &1 already exists.
CPF2F07
Dictionary &1 in error.
CPF2F11
Dictionary &1 not created.
CPF9820
Not authorized to use library &1.
CPF9830
Cannot assign library &1.