Display Data Dictionary (DSPDTADCT)

The Display Data Dictionary (DSPDTADCT) command allows the user to display or print the contents of a field definition, record format definition, or file definition in a data dictionary.

Parameters

Keyword Description Choices Notes
DTADCT Data dictionary Name Required, Positional 1
DFN Definition Generic name, name, *ALL Optional
DFNTYPE Definition type *FILE, *RCDFMT, *FLD Optional
OUTPUT Output *, *PRINT Optional
FILEINF File information *BASIC, *DETAIL, *EXTENDED, *ALL, *NONE Optional
RCDFMTINF Record format information *BASIC, *EXTENDED, *ALL, *NONE Optional
FLDINF Field information *BASIC, *DETAIL, *EXTENDED, *ALL, *NONE Optional
CRTDATE Creation date Date, *FIRST Optional

Data dictionary (DTADCT)

Specifies the name of the data dictionary that contains the definition being displayed or printed.

This is a required parameter.

Definition (DFN)

Specifies the name of the definition that is displayed or printed.

*ALL
All definitions of the type specified in the Definition type prompt (DFNTYPE parameter) are displayed or printed.
definition-name
Specify the name of the definition that is displayed or printed.
generic*-definition-name
Specify the generic name of the definition that is displayed or printed. A generic name is specified as a character string that contains one or more characters followed by an asterisk (*). If a generic object name is specified, then all definitions that have names with the same prefix as the generic name are displayed or printed.

Definition type (DFNTYPE)

Specifies the type of definitions that are displayed or printed.

*FILE
The file definitions are displayed or printed. This value is not valid if *NONE is specified for the File information prompt (FILEINF parameter).
*FLD
The field definitions are displayed or printed. This value is not valid if *NONE is specified for the Field information prompt (FLDINF parameter).
*RCDFMT
The record format definitions are displayed or printed. This value is not valid if *NONE is specified for the Record format information prompt (RCDFMTINF parameter).

Output (OUTPUT)

Specifies whether the output from the command is displayed at the requesting work station or printed with the job's spooled output.

*
The output is displayed for interactive jobs or printed with the job's spooled output for non-interactive jobs.
*PRINT
The output is printed with the job's spooled output.

File information (FILEINF)

Specifies the level of detail that is displayed or printed for the file definition information.

*BASIC
The following basic information is displayed or printed:
  • the definition name
  • the definition type
  • the dictionary in which the definition is located
  • the date the definition was created
  • the user ID of the person who created it
  • the date it was last changed
  • the user ID of the person who made the last change
  • the text of the definition
  • the number of record format definitions used by this file definition
*DETAIL
The basic information, as well as any key field information, is displayed or printed.
*EXTENDED
The detailed information, and any long comment about the file definition, is displayed or printed.
*ALL
The extended information, and a list of files that use this definition, is displayed or printed.
*NONE
No detailed information is printed or displayed about the file definition if *RCDFMT or *FLD is specified for the Definition type prompt (DFNTYPE parameter).

Record format information (RCDFMTINF)

Specifies the level of detail that is printed or displayed for the contents of the record format information.

*BASIC
The following basic information is displayed or printed:
  • the definition name
  • the definition type
  • the dictionary in which the definition is located
  • the date the definition was created
  • the user ID of the person who created it
  • the date it was last changed
  • the user ID of the person who made the last change
  • the text of the definition
  • the number of field definitions used by this record format definition
  • the length of the format
*EXTENDED
The basic information, and any long comment about the record format definition, is displayed or printed.
*ALL
The extended information, any record ID codes, and a list of file definitions and files that use this record format definition are displayed or printed.
*NONE
If *NONE is specified, no detailed information is printed or displayed about the record format definitions in a file definition if *FILE is specified for the Definition type prompt (DFNTYPE parameter). *NONE is not valid if *RCDFMT is specified for the Definition type prompt (DFNTYPE parameter). No information can be printed or displayed about a record format definition if *FLD is specified for the Definition type prompt (DFNTYPE parameter).

Field information (FLDINF)

Specifies the level of detail that is printed or displayed for the field description.

*BASIC
The following basic information is displayed or printed:
  • the definition name
  • the definition type
  • the dictionary in which the definition is located
  • the definition's text
  • the data type
  • the field length
  • the buffer length
  • the buffer position
  • the field usage
  • the column headings
*DETAIL
The basic information is displayed or printed as well as:
  • the date the definition was created
  • the user ID of the person who created it
  • the date it was last changed
  • the user ID of the person who made the last change
  • the alias name
  • editing information
*EXTENDED
The detailed information, and any long comment about the field definition, is displayed.
*ALL
All extended information, and a list of definitions and files that use this definition, is displayed or printed.
*NONE
No detailed information is printed or displayed about the field definition in a record format definition if *FILE or *RCDFMT is specified for the Definition type prompt (DFNTYPE parameter). *NONE is not valid if *FLD is specified for the Definition type prompt (DFNTYPE parameter).

Creation date (CRTDATE)

Specifies the date on which the definition was created.

*FIRST
The first definition created with this name is displayed or printed. If multiple definitions with the same name are created on the same date and that name is specified on the Definition prompt (DFN parameter), only the first definition for that date is displayed or printed. If a generic name or *ALL is specified, the Creation date prompt (CRTDATE parameter) is ignored and all definitions matching the Definition prompt (DFN parameter) are displayed or printed.
date
Specify the creation date of the file definition that is displayed or printed.

Examples 

DSPDTADCT   DTADCT(MINE)  DFN(*ALL)  DFNTYPE(*FILE)
            OUTPUT(*PRINT)  FILEINF(*BASIC)  RCDFMTINF(*BASIC)
            FLDINF(*EXTENDED)

This command prints all file definitions in the data dictionary MINE. Basic information for the file definitions is printed. Basic information for the format definitions in each file definition, and the extended information for the field definitions in each RECORD format definition in the file definitions are printed.

Error messages

*ESCAPE Messages

CPF2DAA
Printer device &1 not found.
CPF2DAC
Not authorized to use printer device &4.
CPF2DAD
Printer device &4 not currently available.
CPF2D76
Name cannot contain an embedded *.
CPF2E9B
Definition &1 not found.
CPF2F02
Not authorized to use dictionary &1.
CPF2F08
Dictionary &1 not found.
CPF3012
File &1 in library &2 not found.
CPF3014
No file specified as &1 in &2 can be displayed.
CPF3024
File &1 not allowed for SYSTEM(&3).
CPF3064
Library &1 not found.
CPF3067
Error while opening file &1 in &2.
CPF3068
Error while writing to file &1 in &2.
CPF3069
Error while closing file &1 in &2.
CPF3074
Not authorized to library &1.
CPF3076
Error occurred when on display.
CPF3077
Error occurred when canceling display.
CPF4253
Not authorized to output queue for device &6.
CPF9850
Override of printer file &1 not allowed.
CPF9851
Overflow value for file &1 in &2 too small.
CPF9852
Page size too narrow for file &1 in &2.