IDMSRPTS

The IDMSRPTS data dictionary reports utility provides information stored in a data dictionary. The utility is a useful tool for database administrators, application programmers, operations personnel, and managers. IDMSRPTS generates reports in four categories.
idmscu19
The IDMSRPTS data dictionary reports utility provides information stored in a data dictionary. The utility is a useful tool for database administrators, application programmers, operations personnel, and managers. IDMSRPTS generates reports in four categories.
This article describes the following information:
2
2
Report Types
This section describes the IDMSRPTS report types.
Non-database reports
Non-database reports provide information on occurrences of data dictionary entities that are not related to database processing.
You do not need to specify a schema, subschema, DMCL, database name table, or segment to get these reports.
Full Report Name
Syntax Name
Description
Global Report Listing
GLBLRPT
Produces all non-database reports
Module/Process/Table Description Listings
MODLST
Produces all module, process, and table reports
Module Description Listing
MODULE
Reports on modules in the dictionary
ADS Process Description Listing
PROCESS
Reports on processes
Protocol Listing
PRTLST
Reports on protocols defined in the data dictionary
Record Copy Description Listing
RECCOPY
Reports on IDD-built records, reports, and transactions
OLQ Qfile Description Listing
QFILE
Reports on q-files defined in the data dictionary
Table Description Listing
TABLE
Reports on edit and code tables
User Listing
USER
Reports on users defined in the data dictionary
Schema Reports
Schema reports provide information on specified schemas defined in the data dictionary.
Full Report Name
Syntax Name
Description
Schema Report Listing
SCHRPT
Produces all schema reports
Area Listing
AREALST
Reports on areas defined in a specified schema
Program Cross-Reference Listing
PGMLST
Reports on subschemas compiled under a specified schema
Schema Record Description Listing
RECDES
Reports on record types defined in a specified schema
Schema Set Description Listing
SETDES
Reports on sets defined in a specified schema
Subschema reports
Subschema reports provide information on specified subschemas defined in the data dictionary.
Full Report Name
Syntax Name
Description
Subschema Report Listing
SSCRPT
Produces all subschema reports
Subschema Data Directory Listing
DATDIR
Provides general information on record types copied into a specified subschema
Logical Record Activity Descriptions
LRACT
Reports on program activity for logical records defined in a specified subschema
Subschema Logical Record Descriptions
LRDEFS
Reports on logical records defined in a specified subschema
Logical Record Path Descriptions
LRPATH
Reports on the paths defined for logical records in a specified subschema
Subschema Area Description Listing
SUBAREA
Reports on areas copied into a specified subschema
Subschema Record Description Listing
SUBREC
Provides comprehensive information on records copied into a specified subschema
Subschema Set Description Listing
SUBSET
Reports on sets copied into a specified subschema
Physical Database Definition reports
Physical database definition reports provide information on specified DMCLs, SEGMENTS, and DBTABLES defined in the dictionary.
Full Report Name
Syntax Name
Description
Physical Database Report Listing
PDBRPT
Produces all physical database definition reports
DBTABLE Listing
DBTLST
Reports on the database names defined in the specified database names table
DMCL Listing
DMCLST
Reports on files, segments, and areas defined in the specified DMCL
Segment Listing
SEGLST
Reports on files, areas, and symbolics defined in the specified segment
Authorization
Physical database definition reports
To
You Need This Privilege or Authority
Run DMCLST report
DBADMIN on the dictionary being processed or DISPLAY on each DMCL on which you want to report
Run SEGLST reports
DBADMIN on the dictionary being processed or DISPLAY on each segment on which you want to report
DBTLST
DBADMIN on the dictionary being processed or DISPLAY on each DBTABLE on which you want to report
Non-database, schema, and subschema reports
To
You Need This Privilege
On
Run any reports except physical database definition reports
SIGNON authority
Dictionary being processed if SECURITY FOR IDD SIGNON IS ON
Run all global reports except physical database definition reports
DISPLAY or higher
Basic entity type on which you want to report if SECURITY FOR IDD SIGNON IS ON
Run schema and subschema reports
DISPLAY or higher
Database entity on which you want to report if SECURITY FOR IDMS IS ON
Run all reports except User Listing and physical database definition reports
DISPLAY or higher
Entity occurrence on which you want to report if the PUBLIC ACCESS IS NONE
Syntax
SIGNON USER statement
  ►►──┬──────────────────────────────────────────────────┬──────────────────────►     └─ SIGnon USEr user-id ─┬────────────────────────┬─┘                             └─ PASsword = password ──┘  
SCHEMA statement
   ►─┬────────────────────────────────────────────────┬─────────────────────────►    └─ SCHema ─┬─────┬─┬─ schema-name ─────────────┬─┘               └─ = ─┘ │     ┌────── , ──────┐     │                       ├─ ( ─▼─ schema-name ─┴─ ) ─┤                       └─ ALL ─────────────────────┘  ►─┬────────────────────────────────────────────────────┬─────────────────────►    └─ Version ─┬─────┬─┬─ version-number ─────────────┬─┘                └─ = ─┘ │     ┌─────── , ────────┐     │                        ├─ ( ─▼─ version-number ─┴─ ) ─┤                        ├─ HIGhest  ◄──────────────────┤                        └─ ALL ────────────────────────┘  
SUBSCHEMA statement
   ►─┬──────────────────────────────────────────────────────────┬───────────────►    └─┬─ SUBschema ─┬─┬─────┬─┬─ subschema-name ─────────────┬─┘      └─ SSC ───────┘ └─ = ─┘ │     ┌─────── , ────────┐     │                              ├─ ( ─▼─ subschema-name ─┴─ ) ─┤                              └─ ALL ────────────────────────┘  
DMCL statement
   ►─┬────────────────────────────────────────────┬─────────────────────────────►    └─ DMCl ─┬─────┬─┬─ dmcl-name ─────────────┬─┘             └─ = ─┘ │     ┌───── , ─────┐     │                     ├─ ( ─▼─ dmcl-name ─┴─ ) ─┤                     └─ ALL ───────────────────┘  
SEGMENT statement
   ►─┬──────────────────────────────────────────────────┬───────────────────────►    └─ SEGment ─┬─────┬─┬─ segment-name ─────────────┬─┘                └─ = ─┘ │     ┌────── , ───────┐     │                        ├─ ( ─▼─ segment-name ─┴─ ) ─┤                        └─ ALL ──────────────────────┘  
DBTABLE statement
   ►─┬─────────────────────────────────────────────────┬────────────────────────►    └─ DBTable ─┬─────┬───┬────── dbtable-name ─────┬─┘                └─ = ─┘   │   ┌────── , ────────┐   │                          ├─(─▼── dbtable-name ─┴─)─┤                          └────── ALL ──────────────┘  
REPORTS SELECTION statement
   ►─┬───────────────────────┬──────────────────────────────────────────────────►◄    └─┬─ ALLRPT ──────────┬─┘      │ ┌───────────────┐ │      └─▼─┬─ AREALST ─┬─┴─┘          ├─ DATDIR ──┤          ├─ DBTLST ──┤          ├─ DMCLST ──┤          ├─ GLBLRPT ─┤          ├─ LRACT ───┤          ├─ LRDEFS ──┤          ├─ LRPATH ──┤          ├─ MODLST ──┤          ├─ MODULE ──┤          ├─ PDBRPT ──┤          ├─ PGMLST ──┤          ├─ PROCESS ─┤          ├─ PRTLST ──┤          ├─ QFILE ───┤          ├─ RECCOPY ─┤          ├─ MornES ──┤          ├─ SCHRPT ──┤          ├─ SEGLST ──┤          ├─ SETDES ──┤          ├─ SSCRPT ──┤          ├─ SUBAREA ─┤          ├─ SUBREC ──┤          ├─ SUBSET ──┤          ├─ TABLE ───┤          └─ USER ────┘  
Statements
Statement descriptions
IDMSRPTS utility processing is controlled by the input statements listed in the following table.
When specifying multiple input statements (other than SIGNON and REPORTS SELECTION), you must specify them in the order listed in the following table.
Statement
Description
SIGNON USER
Identifies the user running IDMSRPTS.
SCHEMA
Specifies the schema(s) to report on.
SUBSCHEMA
Specifies the subschema(s) to report on.
DMCL
Specifies the DMCL(s) to report on.
SEGMENT
Specifies the segment(s) to report on.
DBTABLE
Specifies the database name table(s) to report on.
REPORTS SELECTION
Specifies the report(s) to generate.
SIGNON USER statement
The SIGNON USER statement is provided to override the external user ID for IDD security checking at IDD signon and for entity type and entity occurrence levels for reports other than physical database definition reports.
Your external user ID (from the job card) is always used for physical database definition security checking.
If you do not specify a SIGNON USER statement, your external user ID is also used for IDD security checking.
Use the SIGNON USER statement, specifying the user ID and password of an authorized user, if your external user ID is:
  • Not defined in the dictionary and IDD SIGNON IS ON
  • Is defined in the dictionary but does not have authority to sign on or access the entity-types and occurrences on which you wish to report
If the IDD USER SIGNON OVERRIDE option does not allow signon override, and the external user ID is different from the SIGNON user ID, CA IDMS/DB ignores the SIGNON user ID for all IDD security checking.
If the dictionary is unsecured, you do not need to specify either a user ID or a password.
Syntax
►►──┬──────────────────────────────────────────────────┬──────────────────────►     └─ SIGnon USEr user-id ─┬────────────────────────┬─┘                             └─ PASsword = password ──┘
Parameters
  • user-id
    Identifies a user in the dictionary.
  • PASsword =
    password
    Specifies the password assigned to the user in the data dictionary.
    A password must be provided if a SIGNON statement has been processed, and the specified user ID is not the same as the external user ID and has been assigned a password in the dictionary.
SCHEMA statement
The SCHEMA statement identifies the schema(s) to report on.
A schema statement is required if the reports selection includes any of the following:
  • SCHRPT
  • AREALST
  • PGMLIST
  • RECDES
  • SETDES
Authorization
The identified user must hold authority for:
  • IDD SIGNON if IDD SIGNON is secured and
  • DISPLAY or higher if IDMS is secured and
  • DISPLAY or higher on named schema(s) if PUBLIC ACCESS for the occurrence is NONE
Syntax
 ►─┬────────────────────────────────────────────────┬─────────────────────────►    └─ SCHema ─┬─────┬─┬─ schema-name ─────────────┬─┘               └─ = ─┘ │     ┌────── , ──────┐     │                       ├─ ( ─▼─ schema-name ─┴─ ) ─┤                       └─ ALL ─────────────────────┘  ►─┬────────────────────────────────────────────────────┬─────────────────────►    └─ Version ─┬─────┬─┬─ version-number ─────────────┬─┘                └─ = ─┘ │     ┌─────── , ────────┐     │                        ├─ ( ─▼─ version-number ─┴─ ) ─┤                        ├─ HIGhest  ◄──────────────────┤                        └─ ALL ────────────────────────┘
Parameters
  • SCHema
    Identifies the schema(s) for which specified schema-level reports are to be produced, and/or the schema(s) to which any specified subschema(s) are related.
  • schema-name
    Specifies the name of a schema defined in the data dictionary. You can specify multiple occurrences of
    schema-name
    by enclosing them in parentheses and separating them with commas.
    IDMSRPTS reports only on the named schema(s).
    You can specify up to 25 schema names.
  • ALL
    Directs IDMSRPTS to report on all schemas in the data dictionary.
  • Version
    Specifies version numbers for all the schemas named in the SCHEMA parameter.
  • version-number
    Directs IDMSRPTS to report on the specified versions of each schema.
    You can specify up to 25 version numbers.
  • HIGhest
    Directs IDMSRPTS to report on the highest numbered version of each specified schema.
    This is the default.
  • ALL
    Directs IDMSRPTS to report on all versions of each specified schema.
SUBSCHEMA statement
The SUBSCHEMA statement identifies the subschema(s) to report on.
Both a schema and subschema statement are required if the reports selection includes any of the following:
  • SSCRPT
  • DATDIR
  • LRACT
  • LRDEFS
  • LRPATH
  • SUBREC
  • SUBSET
Authorization
The identified user must hold authority for:
  • IDD SIGNON if IDD SIGNON is secured and
  • DISPLAY or higher if IDMS is secured and
  • DISPLAY or higher on requested schema(s) if PUBLIC ACCESS for the occurrence is NONE
Syntax
►─┬──────────────────────────────────────────────────────────┬───────────────►   └─┬─ SUBschema ─┬─┬─────┬─┬─ subschema-name ─────────────┬─┘     └─ SSC ───────┘ └─ = ─┘ │     ┌─────── , ────────┐     │                             ├─ ( ─▼─ subschema-name ─┴─ ) ─┤                             └─ ALL ────────────────────────┘
Parameters
  • SUBschema/SSC
    Identifies the subschema(s) for which the specified subschema-level reports are to be produced.
    SUBSCHEMA and SSC are synonyms and can be used interchangeably.
  • subschema-name
    Specifies the name of a subschema compiled under a schema identified by the SCHEMA statement.
    IDMSRPTS reports only on the named subschema(s).
    You can specify up to 25 subschema names.
    You can specify multiple occurrences of
    subschema-name
    by enclosing them in parentheses and separating them with commas.
  • ALL
    Directs IDMSRPTS to reports on all subschemas compiled under the schema(s) identified by the SCHEMA statement.
DMCL statement
The DMCL statement identifies the DMCL(s) to report on.
A DMCL statement is required if the reports selection includes DMCLST.
Authorization
The external user ID must hold either DBADMIN authority for the dictionary or DISPLAY authority on requested DMCL(s).
Syntax
►─┬────────────────────────────────────────────┬─────────────────────────────►   └─ DMCl ─┬─────┬─┬─ dmcl-name ─────────────┬─┘            └─ = ─┘ │     ┌───── , ─────┐     │                    ├─ ( ─▼─ dmcl-name ─┴─ ) ─┤                    └─ ALL ───────────────────┘
Parameters
  • DMCl
    Identifies the DMCL(s) for which the DMCLST report is to be produced.
  • dmcl-name
    Identifies the name of a DMCL defined in the catalog component of the dictionary. You can specify multiple occurrences of
    dmcl-name
    by enclosing them in parentheses and separating them with commas.
    IDMSRPTS reports only on the named DMCL(s).
    You can specify up to 25 DMCL names.
  • ALL
    Directs IDMSRPTS to reports on all DMCLs defined in the dictionary.
SEGMENT statement
The SEGMENT statement identifies the segment(s) to report on.
A SEGMENT statement is required if the reports selection includes SEGLST.
Authorization
The external user ID must hold either DBADMIN authority for the dictionary or DISPLAY authority on requested segment(s).
Syntax
►─┬──────────────────────────────────────────────────┬───────────────────────►   └─ SEGment ─┬─────┬─┬─ segment-name ─────────────┬─┘               └─ = ─┘ │     ┌────── , ───────┐     │                       ├─ ( ─▼─ segment-name ─┴─ ) ─┤                       └─ ALL ──────────────────────┘
Parameters
  • SEGment
    Identifies the segment(s) for which the SEGLST report is to be produced.
  • segment-name
    Specifies the name of a segment defined in the catalog component of the dictionary. You can specify multiple occurrences of
    segment-name
    by enclosing them in parentheses and separating them with commas.
    IDMSRPTS reports only on the named segment(s).
    You can specify up to 25 segment names.
  • ALL
    Directs IDMSRPTS to reports on all segments defined in the dictionary.
DBTABLE statement
The DBTABLE statement identifies the database name table(s) to report on.
A DBTABLE statement is required if the reports selection includes DBTLST.
Authorization
The external user ID must hold either DBADMIN authority for the dictionary or DISPLAY authority on requested database names table(s).
Syntax
►─┬─────────────────────────────────────────────────┬────────────────────────►   └─ DBTable ─┬─────┬───┬────── dbtable-name ─────┬─┘               └─ = ─┘   │   ┌────── , ────────┐   │                         ├─(─▼── dbtable-name ─┴─)─┤                         └────── ALL ──────────────┘
Parameters
  • DBTable
    Identifies the database name table(s) for which specified dbtable-level reports are to be produced.
  • dbtable-name
    Identifies the name of a database name table defined in the catalog component of the dictionary. You can specify multiple occurrences of
    dbtable-name
    by enclosing them in parentheses and separating them with commas.
    IDMSRPTS reports only on the named database name table(s).
  • ALL
    Directs IDMSRPTS to report on all database name tables defined in the catalog segment of the dictionary.
REPORTS SELECTION statement
The REPORTS SELECTION statement identifies the reports to generate.
Syntax
►─┬───────────────────────┬──────────────────────────────────────────────────►◄   └─┬─ ALLRPT ──────────┬─┘     │ ┌───────────────┐ │     └─▼─┬─ AREALST ─┬─┴─┘         ├─ DATDIR ──┤         ├─ DBTLST ──┤         ├─ DMCLST ──┤         ├─ GLBLRPT ─┤         ├─ LRACT ───┤         ├─ LRDEFS ──┤         ├─ LRPATH ──┤         ├─ MODLST ──┤         ├─ MODULE ──┤         ├─ PDBRPT ──┤         ├─ PGMLST ──┤         ├─ PROCESS ─┤         ├─ PRTLST ──┤         ├─ QFILE ───┤         ├─ RECCOPY ─┤         ├─ RECDES ──┤         ├─ SCHRPT ──┤         ├─ SEGLST ──┤         ├─ SETDES ──┤         ├─ SSCRPT ──┤         ├─ SUBAREA ─┤         ├─ SUBREC ──┤         ├─ SUBSET ──┤         ├─ TABLE ───┤         └─ USER ────┘
Parameters
  • ALLRPT
    Generates all non-database reports; all reports except DBTLST, DMCLST, and SEGLST.
  • AREALST
    Generates the Area Listing for each specified schema.
  • DATDIR
    Generates the Subschema Data Directory Listing for each specified subschema.
  • DBTLST
    Generates the DBNAMES Table Report.
  • DMCLST
    Generates the DMCL Listing for each specified DMCL.
  • GLBLRPT
    Generates all database independent reports: MODULE, PROCESS, TABLE, RECCOPY, PRTLST, QFILE, and USER.
    No SCHEMA, SUBSCHEMA, DMCL, or SEGMENT statement is required to generate these reports.
  • LRACT
    Generates the Logical Record Activity Descriptions report for each specified subschema.
  • LRDEFS
    Generates the Subschema Logical Record Descriptions report for each specified subschema.
  • LRPATH
    Generates the Logical Record Path Descriptions report for each specified subschema.
  • MODLST
    Generates the module, process, and table reports.
  • MODULE
    Generates the Module Description Listing, which lists each module that you are authorized to display. Processes, tables, qfiles, and protocols are not included in this report.
  • PDBRPT
    Generates the physical database reports: DBTLST, DMCLST, and SEGLST.
    If specified:
    • DMCLST will be produced for all DMCLs identified on DMCL statements
    • SEGLST will be produced for all SEGMENTs identified on SEGMENT statements
    • DBTLST will be produced for all DBTABLES identified on DBTABLE statements
  • PGMLST
    Generates the Program Cross-Reference Listing for each specified schema version.
  • PROCESS
    Generates the ADS Process Description Listing, which lists each process that you are authorized to display.
  • PRTLST
    Generates the Protocol Listing.
  • QFILE
    Generates the OLQ Qfile Description Listing.
  • RECCOPY
    Generates the Record Copy Description Listing, which lists each IDD-built record, report, and transaction that you are authorized to display.
  • RECDES
    Generates the Schema Record Description Listing for each specified schema version.
  • SCHRPT
    Generates all schema reports for each specified schema version: AREALST, PGMLST, RECDES, and SETDES.
    The schema reports do not report on unvalidated schemas or schemas that have errors.
  • SEGLST
    Generates the Segment Listing for each specified segment.
  • SETDES
    Generates the Set Description Listing for each specified schema version.
  • SSCRPT
    Generates all subschema reports for each specified subschema, schema, and version: DATDIR, LRACT, LRDEFS, LRPATH, SUBREC, and SUBSET.
    The subschema reports do not report on unvalidated subschemas or subschemas that contain errors.
  • SUBAREA
    Generates the Subschema Area Description Listing for each specified subschema.
  • SUBREC
    Generates the Subschema Record Description Listing for each specified subschema.
  • SUBSET
    Generates the Subschema Set Description Listing for each specified subschema.
  • TABLE
    Generates the Table Description Listing, which lists each table that you are authorized to display.
  • USER
    Generates the User Listing.
Usage
Input
Input to the IDMSRPTS utility consists of statements to control the utility processing.
When specifying multiple input statements (other than SIGNON and REPORTS SELECTION), you must specify them in this order:
  1. SCHEMA
  2. SUBSCHEMA
  3. DMCL
  4. SEGMENT
  5. DBTABLE
Specifying a dictionary name and nodename
To override the default dictionary name or dictionary nodename the IDMSRPTS utility uses to produce reports, use the DICTNAME and DICTNODE parameters in the SYSIDMS parameter file.
Output
The IDMSRPTS utility generates reports on information stored in a data dictionary.
Batch operating mode
You can execute the IDMSRPTS utility either in local mode or under the central version.
JCL Considerations
For more information about the JCL used to execute IDMSRPTS, see the section for your operating system in this section.
Examples
Protocol Listing
The following input parameters direct IDMSRPTS to generate the Protocol Listing.
prtlst
DMCL, SEGMENT, DBTABLE Listing
The following input parameters direct IDMSRPTS to generate the DMCL Listing for the DMCL IDMSDMCL, a Segment Listing for each segment defined in the dictionary and a DBTABLE Listing for each DBTABLE defined in the dictionary.
dmcl=idmsdmcl segment=all dbtable=all pdbrpt
Schema Record and Set Description Listing
The following input parameters direct IDMSRPTS to generate the Schema Record Description Listing and the Set Description Listing for versions 1, 99, and 100 of the schema EMPSCHM.
schema=empschm version=(1, 99, 100) recdes setdes
Subschema Area and Data Directory Listing
The following input parameters direct IDMSRPTS to generate the Subschema Area Description Listing and the Subschema Data Directory Listing for each subschema compiled under the highest existing version of the schema EMPSCHM.
schema=empschm subschema=all subarea datdir
Sample Output
Protocol Listing
                          GLOBAL                        PRTLST IDMSRPTS nn.n                              ----------- PROTOCOL LISTING -----------                      DATE     TIME   PAGE PRTLST                                           DICTIONARY SYSTEM   OF NODE DEFAULT                       mm/dd/yy  180854     1 PROTOCOL NAME .. BATCH PROTOCOL VERSION 0001 DATE CREATED ... mm/dd/yy LAST UPDATED ... N/A LANGUAGE ....... COBOL                                            MOVE @DMLSEQ TO DML-SEQUENCE                                            MOVE @OCCUR TO RECORD-OCCUR                                            MOVE @NODN TO SSC-NODN                                            MOVE @DBN TO SSC-DBN                                            MOVE @DICTNO TO SSC-DNO                                            MOVE @DICTNA TO SSC-DNA                                            MOVE @LNG TO LRC-LRPXELNG                                            MOVE @LRSIZE TO LRC-MAXVXP                                            MOVE '@LRSTAT' TO LR-STATUS                                            MOVE '@VERB' TO LRVERB                                            MOVE '@NAME' TO LRNAME                           @(PXELP                                            MOVE @XDE TO @PXE                                            ADD @PXELNG TO LRC-LRPXELNG                           @)PXELP                           @(MISCLOOP                                            @MISC                           @)MISCLOOP                                            CALL 'IDMS' USING SUBSCHEMA-CTRL  @CALLIDMS                                                    IDBMSCOM (@FUNC1)                                                    @SSCTRL                                                    @SSNAME                                                    @SSLRCTRL                                                    @REC                                                    @SET                                                    @AREA                                                    @DATANAME                                                    @RECBUF                                                    @OCCUR2                                                    IDBMSCOM (@FUNC2)                                                    IDBMSCOM (@KEEP)                                                    @P1                                                    @P2                                                    @P3                                                    @P4                           @(PALOOP                                                    @PA1                                                    @PA2                                                    @PA3                           @)PALOOP                                                                            @PERIOD                                            IF ERROR-STATUS EQUAL TO '@STATUS'                     ...
DMCL, SEGMENT, and DBTABLE Listing
IDMSRPTS nn.n                              ------------- DMCL LISTING -------------                      DATE     TIME   PAGE DMCLST                                       DICTIONARY SYSTEM   OF NODE DEFAULT                       mm/dd/yy  181203     1                                                          DMCL CVDMCL13                                          EXTERNAL  LOW  REL  HIGH REL    PAGE  LOW PAGE  CALC HIGH  HIGH PAGE  BLK/PAGE    PAGE                                            NAME    BLOCK NR  BLOCK NR   GROUP   NUMBER    PAGE NR    NUMBER      SIZE      RESV SEGMENT ................ APPLCAT                                               0     FILE ............... APPLCAT         APPLCAT          1      1000                                            4276         AREA ........... DDLCAT                           1      1000      0    304001     305000     305000     4276         0     FILE ............... APPLCATX        APPLCATX         1       500                                            4276         AREA ........... DDLCATX                          1       500      0    306001     306500     306500     4276         0     FILE ............... APPLCATL        APPLCATL         1       500                                            4276         AREA ........... DDLCATLOD                        1       500      0    308001     308500     308500     4276         0 SEGMENT ................ APPLNWK                                               0     FILE ............... APPLDML         APPLDML          1      1000                                            4276         AREA ........... DDLDML                           1      1000      0    300001     301000     301000     4276         0     FILE ............... APPLLOD         APPLLOD          1       500                                            4276         AREA ........... DDLDCLOD                         1       500      0    302001     302500     302500     4276         0 SEGMENT ................ ASFNWK                                                0     FILE ............... ASFDML          ASFDML           1      1000                                            4276         AREA ........... DDLDML                       1      1000          0    400001     401000     401000     4276         0     FILE ............... ASFLOD          ASFLOD           1       500                                            4276         AREA ........... DDLDCLOD                         1       500      0    402001     402500     402500     4276         0     FILE ............... ASFDEFN         ASFDEFN          1       500                                            4276         AREA ........... IDMSR-AREA                       1       500      0    404001     404500     404500     4276         0     FILE ............... ASFDATA         ASFDATA          1       500                                            4276         AREA ........... IDMSR-AREA2                      1       500      0    406001     406500     406500     4276         0 SEGMENT ................ CATSYS                                                0     FILE ............... DCCAT           DCCAT            1       100                                            4276                                  ... IDMSRPTS nn.n                              ----------- SEGMENT LISTING ------------                      DATE     TIME   PAGE SEGLST                                       DICTIONARY SYSTEM   OF NODE DEFAULT                       mm/dd/yy  181203     1                                                SEGMENT APPLCAT   PAGE GROUP    0                                          EXTERNAL  LOW  REL  HIGH REL    PAGE  LOW PAGE  CALC HIGH  HIGH PAGE  BLK/PAGE    PAGE                                            NAME    BLOCK NR  BLOCK NR   GROUP   NUMBER    PAGE NR    NUMBER      SIZE      RESV SEGMENT ................ APPLCAT                                               0     AREA ............... DDLCAT                                            0    304001     305000     305000     4276         0         WITHIN FILE .... APPLCAT         APPLCAT          1      1000           304001                305000     4276     AREA ............... DDLCATX                                           0    306001     306500     306500     4276         0         WITHIN FILE .... APPLCATX        APPLCATX         1       500           306001                306500     4276     AREA ............... DDLCATLOD                                         0    308001     308500     308500     4276         0         WITHIN FILE .... APPLCATL        APPLCATL         1       500           308001                308500     4276                           ... IDMSRPTS nn.n        ----------- DBTABLE LISTING ------------       DATE     TIME   PAGE DBTLST                 DICTIONARY SYSTEM   OF NODE DEFAULT        mm/dd/yy  181203     1                                  DBTABLE CVDBTB13 DBTABLE ......... CVDBTB13     DBTABLE MAPPINGS         SUBSCHEMA IDMSCAT?   MAPS TO SUBSCHEMA IDMSCAT?   USING DBNAME SYSTEM         SUBSCHEMA IDMSNWK?   MAPS TO SUBSCHEMA IDMSNWK?   USING DBNAME SYSTEM         SUBSCHEMA IDMSRSSA   MAPS TO SUBSCHEMA IDMSRSSA   USING DBNAME ASFDICT         SUBSCHEMA RC??????   MAPS TO SUBSCHEMA RC??????   USING DBNAME ASFDICT         SUBSCHEMA RU??????   MAPS TO SUBSCHEMA RU??????   USING DBNAME ASFDICT         SUBSCHEMA CITSALLP   MAPS TO SUBSCHEMA CITSALLP   USING DBNAME INFODB         SUBSCHEMA MTSSINFP   MAPS TO SUBSCHEMA MTSSINFP   USING DBNAME INFODB     DBNAME ...... APPLDICT   MATCH ON SUBSCHEMA OPTIONAL         SEGMENT   APPLCAT         SEGMENT   APPLNWK         SEGMENT   SYSMSG     DBNAME ...... ASFDICT    MATCH ON SUBSCHEMA OPTIONAL         SEGMENT   ASFNWK         SEGMENT   SYSMSG     DBNAME ...... DIRLDICT   MATCH ON SUBSCHEMA OPTIONAL         SEGMENT   DIRLNWK         SEGMENT   SYSMSG     DBNAME ...... INFODB     MATCH ON SUBSCHEMA OPTIONAL         SEGMENT   INFOTSIS         SEGMENT   TSIS     DBNAME ...... INFODICT   MATCH ON SUBSCHEMA OPTIONAL         SEGMENT   INFONWK     DBNAME ...... SYSTEM     MATCH ON SUBSCHEMA OPTIONAL         SEGMENT   CATSYS         SEGMENT   SYSMSG         SEGMENT   SYSTEM                       ...
Schema Record and Set Description Listing
IDMSRPTS nn.n                              -- SCHEMA RECORD DESCRIPTION LISTING ---                       DATE     TIME   PAGE RECDES                                       DICTIONARY APPLDICT OF NODE DEFAULT                        mm/dd/yy  181426     1                                                  SCHEMA EMPSCHM  VERSION    1 RECORD NAME........ COVERAGE                                                                                      RLGTH=   36 RECORD VERSION..... 0001                                                                                          DLGTH=   16 RECORD ID.......... 0400                                                                                          KLGTH=   20 RECORD LENGTH...... FIXED                                                                                         DSTRT=   20 LOCATION MODE...... VIA SET      EMP-COVERAGE        DISPLACEMENT 0000  PAGES WITHIN............. INS-DEMO-REGION     OFFSET          5 PGS FOR         45 PGS DBKEY POSITIONS.... SET............. TYPE........ NEXT  PRIOR OWNER                     EMP-COVERAGE     MEMBER          1     2     3                     COVERAGE-CLAIMS  OWNER           4     5 DATA ITEM.......... REDEFINES....... USAGE....... VALUE............................. PICTURE.....................  STRT  LGTH 02 SELECTION-DATE-0400               DISPLAY                                                                          1     6 03 SELECTION-YEAR-0400               DISPLAY                                         9(2)                             1     2 03 SELECTION-MONTH-0400              DISPLAY                                         9(2)                             3     2 03 SELECTION-DAY-0400                DISPLAY                                         9(2)                             5     2 02 TERMINATION-DATE-0400             DISPLAY                                                                          7     6 03 TERMINATION-YEAR-0400             DISPLAY                                         9(2)                             7     2 03 TERMINATION-MONTH-0400            DISPLAY                                         9(2)                             9     2 03 TERMINATION-DAY-0400              DISPLAY                                         9(2)                            11     2 02 TYPE-0400                         DISPLAY                                         X                               13     1 88 MASTER-0400                       COND         'M'                                                                13 88 FAMILY-0400                       COND         'F'                                                                13 88 DEPENDENT-0400                    COND         'D'                                                                13 02 INS-PLAN-CODE-0400                DISPLAY                                         X(3)                            14     3 88 GROUP-LIFE-0400                   COND         '001'                                                              14 88 HMO-0400                          COND         '002'                                                              14 88 GROUP-HEALTH-0400                 COND         '003'                                                              14 88 GROUP-DENTAL-0400                 COND         '004'                                                              14 *****                                                                                                                          ***** REC SYNONYM NAME... COVERGE                           COVERAGE                                                    RLGTH=   36 REC SYNONYM VER.... 0001                                                                                          DLGTH=   16 LANGUAGE(S)........ ASSEMBLER DATA ITEM.......... REDEFINES....... USAGE....... VALUE............................. PICTURE.........................  STRT  LGTH 02 COVSELDT                          DISPLAY                                                                          1     6 03 COVSELYR                          DISPLAY                                         9(2)                             1     2 03 COVSELMO                          DISPLAY                                         9(2)                             3     2 03 COVSELDA                          DISPLAY                                         9(2)                             5     2 02 COVTRMDT                          DISPLAY                                                                          7     6 03 COVTRMYR                          DISPLAY                                         9(2)                             7     2 03 COVTRMMO                          DISPLAY                                         9(2)                             9     2 03 COVTRMDA                          DISPLAY                                         9(2)                            11     2 02 COVTYPE                           DISPLAY                                         X                               13     1 88 COVMASTR                          COND         'M'                                                                13 88 COVFAMLY                          COND         'F'                                                                13 88 COVDPNDT                          COND         'D'                                                                13  .  .  . IDMSRPTS nn.n                              -------- SET DESCRIPTION LISTING -------                      DATE     TIME   PAGE SETDES                                       DICTIONARY APPLDICT OF NODE DEFAULT                       mm/dd/yy  181426     1                                                  SCHEMA EMPSCHM  VERSION    1 SET...... CALC              MODE CHAIN              ORDER SORTED OWNER.... SR1               0001 NEXT PRIOR MEMBER... SYSTEM            0007 NEXT PRIOR        MANDATORY AUTO MEMBER... DEPARTMENT        0410 NEXT PRIOR        MANDATORY AUTO                                        NAT DUP NOT ALLOW   IN AREA ORG-DEMO-REGION                                CALC KEY   DEPT-ID-0410                     ASC MEMBER... EMPLOYEE          0415 NEXT PRIOR        MANDATORY AUTO                                        NAT DUP NOT ALLOW   IN AREA EMP-DEMO-REGION                                CALC KEY   EMP-ID-0415                      ASC MEMBER... INSURANCE-PLAN    0435 NEXT PRIOR        MANDATORY AUTO                                        NAT DUP NOT ALLOW   IN AREA INS-DEMO-REGION                                CALC KEY   INS-PLAN-CODE-0435               ASC MEMBER... JOB               0440 NEXT PRIOR        MANDATORY AUTO                                        NAT DUP NOT ALLOW   IN AREA ORG-DEMO-REGION                                CALC KEY   JOB-ID-0440                      ASC MEMBER... OFFICE            0450 NEXT PRIOR        MANDATORY AUTO                                        NAT DUP NOT ALLOW   IN AREA ORG-DEMO-REGION                                CALC KEY   OFFICE-CODE-0450                 ASC MEMBER... SKILL             0455 NEXT PRIOR        MANDATORY AUTO                                        NAT DUP NOT ALLOW   IN AREA ORG-DEMO-REGION                                CALC KEY   SKILL-ID-0455                    ASC SET...... COVERAGE-CLAIMS   MODE CHAIN              ORDER LAST OWNER.... COVERAGE          0400 NEXT PRIOR   IN AREA INS-DEMO-REGION MEMBER... HOSPITAL-CLAIM    0430 NEXT PRIOR        MANDATORY AUTO   IN AREA INS-DEMO-REGION MEMBER... NON-HOSP-CLAIM    0445 NEXT PRIOR        MANDATORY AUTO   IN AREA INS-DEMO-REGION MEMBER... DENTAL-CLAIM      0405 NEXT PRIOR        MANDATORY AUTO   IN AREA INS-DEMO-REGION SET...... DEPT-EMPLOYEE     MODE CHAIN              ORDER SORTED OWNER.... DEPARTMENT        0410 NEXT PRIOR   IN AREA ORG-DEMO-REGION MEMBER... EMPLOYEE          0415 NEXT PRIOR OWNER  OPTIONAL  AUTO                                        NAT DUP LAST   IN AREA EMP-DEMO-REGION                                SORT KEY   EMP-LAST-NAME-0415               ASC                                                                     EMP-FIRST-NAME-0415              ASC SET...... EMP-COVERAGE      MODE CHAIN              ORDER FIRST OWNER.... EMPLOYEE          0415 NEXT PRIOR   IN AREA EMP-DEMO-REGION MEMBER... COVERAGE          0400 NEXT PRIOR OWNER  MANDATORY AUTO   IN AREA INS-DEMO-REGION SET...... EMP-EMPOSITION    MODE CHAIN              ORDER FIRST OWNER.... EMPLOYEE          0415 NEXT PRIOR   IN AREA EMP-DEMO-REGION MEMBER... EMPOSITION        0420 NEXT PRIOR OWNER  MANDATORY AUTO  .  .  .
Subschema Area and Data Directory Listing
IDMSRPTS nn.n         -- SUBSCHEMA DATA DIRECTORY LISTING --        DATE     TIME   PAGE DATDIR                 DICTIONARY APPLDICT OF NODE DEFAULT        mm/dd/yy  181529     1                SUBSCHEMA EMPHTL1  OF SCHEMA EMPSCHM  VERSION  100 RECORD:      COVERAGE                         ID:  0400 VER:  100   TYPE: I LEN:    16           DATA NAME               LEVEL STRT LENGTH  TYPE    PICTURE   SELECTION-DATE-0400               02     1     6  GROUP   SELECTION-YEAR-0400               03     1     2  DISPLAY  9(2)   SELECTION-MONTH-0400              03     3     2  DISPLAY  9(2)   SELECTION-DAY-0400                03     5     2  DISPLAY  9(2)   TERMINATION-DATE-0400             02     7     6  GROUP   TERMINATION-YEAR-0400             03     7     2  DISPLAY  9(2)   TERMINATION-MONTH-0400            03     9     2  DISPLAY  9(2)   TERMINATION-DAY-0400              03    11     2  DISPLAY  9(2)   TYPE-0400                         02    13     1   A/N     X   MASTER-0400                       88              COND                                   VALUE 'M'   FAMILY-0400                       88              COND                                   VALUE 'F'   DEPENDENT-0400                    88              COND                                   VALUE 'D'   INS-PLAN-CODE-0400                02    14     3   A/N     X(3)   GROUP-LIFE-0400                   88              COND                                   VALUE '001'   HMO-0400                          88              COND                                   VALUE '002'   GROUP-HEALTH-0400                 88              COND                                   VALUE '003'   GROUP-DENTAL-0400                 88              COND                                   VALUE '004'  .  .  . IDMSRPTS nn.n         -- SUBSCHEMA DATA DIRECTORY LISTING --        DATE     TIME   PAGE DATDIR                 DICTIONARY APPLDICT OF NODE DEFAULT        mm/dd/yy  181529     2                SUBSCHEMA EMPHTL1  OF SCHEMA EMPSCHM  VERSION  100 RECORD:      COVERGE                          ID:  0400 VER:  100   TYPE: I LEN:    16 SYNONYM OF:  COVERAGE LANGUAGE(S): ASSEMBLER           DATA NAME               LEVEL STRT LENGTH  TYPE    PICTURE   COVSELDT                          02     1     6  GROUP   COVSELYR                          03     1     2  DISPLAY  9(2)   COVSELMO                          03     3     2  DISPLAY  9(2)   COVSELDA                          03     5     2  DISPLAY  9(2)   COVTRMDT                          02     7     6  GROUP   COVTRMYR                          03     7     2  DISPLAY  9(2)   COVTRMMO                          03     9     2  DISPLAY  9(2)   COVTRMDA                          03    11     2  DISPLAY  9(2)   COVTYPE                           02    13     1   A/N     X   COVMASTR                          88              COND                                   VALUE 'M'   COVFAMLY                          88              COND                                   VALUE 'F'   COVDPNDT                          88              COND                                   VALUE 'D'   COVPLNCD                          02    14     3   A/N     X(3)   GROUP-LIFE                        88              COND                                   VALUE '001'   HMO                               88              COND                                   VALUE '002'   GROUP-HEALTH                      88              COND                                   VALUE '003'   GROUP-DENTAL                      88              COND                                   VALUE '004'  .  .  .