Example 5

Here, the user had a schema containing multiple CALC and sort keys. The purpose of this example is just to show what CA IDMS Schema Mapper does with multiple CALC and sort keys; it does not demonstrate an additional use of parameter statements.

Parameters Entered--The user entered a single PROCESS statement to request that CA IDMS Schema Mapper produce the data structure Diagram and Cross-Reference Report automatically and according to default values. See Exhibit 4.13.

Output Produced--Exhibits 4.14 and 4.15 show the data structure Diagram and the Cross-Reference Report. Note that every record block has enough space to accommodate the record type with the most CALC keys. Also note that every set description has enough space to accommodate the set with the most sort keys.

PROCESS=SUBSCHEMA, SCHEMA=DS16MULT, SUBSCHEMA=DB16MULTI, VERSION=1,
    DICTNAME=TKIT

Exhibit 4.13: Example 5--Parameters Entered

Exhibit 4.14: Default CA IDMS Schema Mapper Data Structure Diagram with Multiple CALC Keys

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 94, 27 / AA ARTS 150, 27 / BA CLASS 94, 74 / AB CON-TROL 1, 12 / AA DEPT 39, 48 / AA DREPORT 39, 12 / AA GREPORT 39, 27 / AA MUSIC 150, 48 / BA PERIOD 94, 95 / AB PREREQ 39, 95 / AB ────── 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 94, 27 / AA ARTS 150, 27 / BA ACTIVITY-TYPES NP OA LAST MUSIC 150, 48 / BA ACTIVITY-TYPES NP OA LAST SPORTS 150, 74 / BB ACTIVITY-TYPES NPO OM LAST 2 CLASS-SCHEDULE CLASS 94, 74 / AB SCHEDULE 150, 12 / BA CLASS-SCHEDULE NPO MA ASC ROSTER-NO DL 3 DEPT-ACADEMIC DEPT 39, 48, / AA SUBJECT 39, 74 / AB DEPT-ACADEMIC NO MM NEXT 4 DEPT-GENERAL DEPT 39, 48 / AA SUBJECT 39, 74 / AB DEPT-GENERAL NO MM NEXT 5 DEPT-TEACHER DEPT 39, 48 / AA TEACHER 94, 48 / AA DEPT-TEACHER NPO OM ASC TCHR-NAME DL ASC TCHR-ID DL ASC TCHR-SUBJECT DL 6 IX-DEPT-NAME SYSTEM (SR7) DEPT 39, 48 / AA IX-DEPT-NAME N MA MODE=INDEX ASC DEPT-NAME DF 7 IX-STUD-LNAME SYSTEM (SR7) STUDENT 94, 12 / AA IX-STUD-LNAME N MA MODE=INDEX DESC DBKEY DL

Exhibit 4.15: Default Cross-Reference Report with Multiple Sort Keys