Example 3

Here, the user wanted to modify the format of record blocks in the CA IDMS Schema Mapper data structure diagram and the descriptions of sets in the Cross-Reference Report (see Exhibits 4.9 and 4.10).

Why record blocks and set descriptions were modified--The user's predefined record block formats and set descriptions differed slightly from CA IDMS Schema Mapper's default specifications. Also, the REC-NAME field does not meet the user's requirements, but the user wants to include a more meaningful record description in the record block. The user did this by including the REC-DESC field and choosing these fields for the record block:

A blank field (for aesthetic reasons) between the LENGTH field and the LOC-MODE field in the second line of the record block
A blank line for handwritten notes for the third line of the record block
A REC-DESC field for descriptive names for the fourth line of the record block.

The user did not want the LOC-CTRL and AREA fields included in the record block, so the user did not enter them in a DRECLINE statement. (See Exhibit 4.8.)

Note: The user's modifications to the format of the record block also change the size and the shape of the record blocks in the diagram.

For set descriptions, the user wanted:

A blank field between POINTERS and MEM-OPT
A blank line for handwritten notes for the third line of the set description.

Also, the user did not want the SET-ORDER field included in the set description, so the user did not enter an XSETLINE statement for it. (See Exhibit 4.8.)

Parameters Entered--The user wrote DRECLINE and XSETLINE statements from scratch to a Parameters Statements File to globally modify the record block format and the set description (see Exhibit 4.8).

Note: When the user specified DRECLINE and XSETLINE parameters, all defaults for the record block and the set description were canceled. The user had to rebuild the entire record block (content) with DRECLINE and the entire set description with XSETLINE.

 PROCESS=SUBSCHEMA, SCHEMA=DSRR1016, SUBSCHEMA=DBRR1016, VERSION=1,
     DICTNAME=TKIT

         OPTIONS,COMPRESS=ON

         CHARDEF,RHORCHAR==,RVERCHAR=:,SLLCHAR=L,SLRCHAR=J,
             SULCHAR=F,SURCHAR=7,LARROW=C,RARROW=D,ISLACHAR=X

         DRECLINE REC-NAME
         DRECLINE REC-ID,BLANK 5,LOC-MODE,DUPS-OPT
         DRECLINE LENGTH-MODE,LENGTH
         DRECLINE LABEL'COUNT',UN-NUM-OCC

         XSETLINE SET-NAME
         XSETLINE POINTERS,BLANK 8,MEM-OPT
         XSETLINE

Exhibit 4.8: Example 3--Parameters Entered

Exhibit 4.9: Tailored CA IDMS Schema Mapper Data Structure Diagram with Record Blocks Modified

CA IDMS Schema Mapper: mm/dd/yy hh:mm:ss SUBSCHEMA DBRR1016, SCHEMA DSRR1016, VERSION 1, DICTNAME=TKIT, DBNAME= RECORD CROSS-REFERENCE LISTING RECORD NAME LOCATION / PAGE ----------- ------------------ ACTIVITY 70, 27 / AA ARTS 114, 27 / BA CLASS 70, 74 / AB CON-TROL 1, 12 / AA DEPT 27, 48 / AA DREPORT 27, 12 / AA GREPORT 27, 27 / AA MUSIC 114, 48 / BA PERIOD 70, 95 / AB PREREQ 27, 95 / AB ROOM 114, 95 / BB SCHEDULE 114, 12 / BA SPORTS 114, 74 / BB STUDENT 70, 12 / AA SUBJECT 27, 74 / AB TEACHER 70, 48 / AA ────── CA IDMS Schema Mapper: mm/dd/yy hh:mm:ss SUBSCHEMA DBRR1016, SCHEMA DSRR1016, VERSION 1, DICTNAME=TKIT, DBNAME= SET/INDEX CROSS-REFERENCE LISTING SET NUMBER SET OR INDEX NAME OWNER LOCATION / PAGE MEMBER LOCATION / PAGE ------ ----------------- --------------------------------------- ------------------------------------ 1 ACTIVITY-TYPES ACTIVITY 70, 27 / AA ARTS 114, 27 / BA ACTIVITY-TYPES NPO OA MUSIC 114, 48 / BA ACTIVITY-TYPES NPO OA SPORTS 114, 74 / BB ACTIVITY-TYPES NPO OM 2 CLASS-SCHEDULE CLASS 70, 74 / AB SCHEDULE 114, 12 / BA CLASS-SCHEDULE NPO MA 3 DEPT-ACADEMIC DEPT 27, 48, / AA SUBJECT 27, 74 / AB DEPT-ACADEMIC NO MM 4 DEPT-GENERAL DEPT 27, 48 / AA SUBJECT 27, 74 / AB DEPT-GENERAL NO MM 5 DEPT-TEACHER DEPT 27, 48 / AA TEACHER 70, 48 / AA DEPT-TEACHER NPO OM 6 IX-DEPT-NAME SYSTEM (SR7) DEPT 27, 48 / AA IX-DEPT-NAME N MA 7 IX-STUD-LNAME SYSTEM (SR7) STUDENT 70, 12 / AA IX-STUD-LNAME N MA

Exhibit 4.10: Tailored Cross-Reference Report with Modified Set Descriptions