Standard Dictionary Reports—DREPORTS › Basic Entity Reports › Record Reports (DREPORTs 008, 038, 058, 078) › Record Detail and Key Report (DREPORTs 008 and 078)

Record Detail and Key Report (DREPORTs 008 and 078)

Contents

The record detail report provides detailed information about all record occurrences; the record key report provides similar information about selected record occurrences. The fields and format of these two reports are the same.

The report below shows sample output for DREPORT 078. The DREPORT and KEY parameters used to create this sample report are:

DREPORT=078
 KEY SR-NAM-036 'LHNREC'

Sample DREPORT 078:

 REPORT NO. 78                                   DATA DICTIONARY REPORTER  REL nn.n                       mm/dd/yy        PAGE   1
 DREPORT 078                                               RECORD REPORT


 *********************************************************************************************************************************
                                             RECORD               RECORD                    ---- D A T E ----
 RECORD NAME                                LENGTH  BUILDER        TYPE       OCCURRENCES   UPDATED   CREATED
 *********************************************************************************************************************************


 LHNREC                           VER     1    28      D                                    mm/dd/yy mm/dd/yy
     PREPARED BY          LHN
     REVISED BY           LHN
     PUBLIC ACCESS ALLOWED FOR ALL AUTHORITY
     USER LHN                               RESPONSIBLE FOR CREATION AND UPDATE AND DELETION
     LANGUAGE             COBOL
     LANGUAGE             ASSEMBLER
     ASSOCIATED RECORD
          TEST-REC                                                 VER     1
     PRIMARY FILE         TESTFILE                                 VER     1
     DEFINITION
              100 DELETION DATE
     RECORD               LHNREC                                   VER     1 D
         LANGUAGE             COBOL
         LANGUAGE             ASSEMBLER
         FILE                 TESTFILE                                 VER     1
            100   02 START-DATE                               X(6)                             DISPLAY
                          VALUE                   'YYMMDD'
            200   02 FINISH-DATE                                                               DISPLAY

Field Descriptions

The format of DREPORTs 008 and 078 depends on the order in which information was defined to the dictionary. A description of the fields in the sample report follows:

RECORD NAME

Identifies the name and version number of the record occurrence.

RECORD LENGTH

Identifies the record length in bytes.

BUILDER

Identifies the compiler last used to add or update the record occurrence. Possible values are D (DDDL compiler), S (schema compiler), C (mapping compiler), and X (IDMSDIRL).

RECORD TYPE

Identifies the record storage mode, if defined.

OCCURRENCES

Identifies the actual or estimated number of times the record occurs in files or databases.

DATE UPDATED/CREATED

Identifies the date the record occurrence was last updated and the date the record occurrence was added to the dictionary.

PREPARED/REVISED BY

Identifies the name of the user who defined the record occurrence and the name of the user who last updated it.

DESCRIPTION

Identifies text associated with the record occurrence.

PUBLIC ACCESS

Identifies the level of access allowed for unregistered users.

USER

Identifies a user who is registered to access the record occurrence and identifies the responsibility code and any associated text defined for the user. If no users are registered, the USER literal does not appear; if no responsibility codes have been defined for the user, the RESPONSIBLE FOR literal does not appear.

Class/attribute associations

Identifies class/attribute associations that have been defined for the record occurrence are listed in this field. In this sample report, the attribute DOCUMENT within class DIVISION is associated with LHNREC.

SAME AS

Identifies the record occurrence from which this record occurrence was copied (if copied).

MODE

Identifies the operating mode for the program in which the record is used.

LANGUAGE

Identifies the language associated with the record occurrence.

User-defined nests

Identify user-defined nests that relate the record occurrence to another record occurrence. In this sample report, the relational key ASSOCIATED RECORD relates record LHNREC to record TEST-REC.

PRIMARY FILE

Identifies the file associated with the record.

COMMENT

Identifies commentary text supplied for the record occurrence through the COMMENTS clause of the DDDL RECORD statement.

User-defined comments

Identify user-defined comments that were defined through the DEFINITION/OLQ HEADER/CULPRIT HEADER/comment-key clause of the DDDL RECORD statement are listed in this field. In this sample report, DELETION DATE is a comment key.

RECORD

Identifies a primary record and provides a description of the elements associated with the record. If defined, the language associated with the record and the programs, files, and subschemas associated with the record are displayed.

IN SCHEMA/AREA

Identifies the name and version number of the schema and the area in which the record occurs.

RECORD SYNONYM

Identifies a record synonym and provides a description of the elements associated with the record synonym. The associated language is also displayed, if defined.

SUBSCHEMA

Identifies the subschema in which this record is used and provides a description of the elements associated with the subschema.

SUBSCHEMA VIEW

Indicates that the record is used in a view and provides a description of the elements (fields) used in the view.