Example 1

The data structure diagram and Cross-Reference Report in Exhibits 4.2 thru 4.5 were produced the first time the user ra CA IDMS Schema Mapper. The user wanted to see the automatic default output and then determine whether to tailor it.

Parameters Entered--The user entered a single PROCESS statement to request that CA IDMS Schema Mapper draw the data structure diagram automatically and according to default values.

Exhibit 4.2 lists the parameter statement used and shows the resulting Transfer File. You can use the Transfer File as input to create the identical diagram at a later time, and you can edit it to tailor the output.

Note: The outputs shown in Examples 2 through 4 are tailored variations of the output in this example.

 PROCESS=SUBSCHEMA, SCHEMA=TSDSCHM1, VERSION=1, SUBSCHEMA=TSDSUBS1,
 DICTNAME=SMAP

Exhibit 4.2: Example 1--Parameters Entered

PROCESS=SUBSCHEMA, SCHEMA=TSDSCHM1, VERSION=1, SUBSCHEMA=TSDSUBS1, DICTNAME=SMAP $$$ NO LOCATE STATEMENTS WERE PROVIDED BY THE USER $$$ $$$ LOCATE STATEMENTS GENERATED BY Schema Mapper $$$ LOCATE STUDENT LOCATE ACTIVITY DOWN 1 FROM STUDENT LOCATE ARTS RIGHT 1 FROM ACTIVITY LOCATE MUSIC RIGHT 1 DOWN 1 FROM ACTIVITY LOCATE SPORTS RIGHT 1 DOWN 2 FROM ACTIVITY LOCATE DREPORT LEFT 1 FROM STUDENT LOCATE GREPORT LEFT 1 DOWN 1 FROM STUDENT LOCATE SCHEDULE RIGHT 1 FROM STUDENT LOCATE DEPT LEFT 1 DOWN 2 FROM STUDENT LOCATE SUBJECT DOWN 1 FROM DEPT LOCATE PREREQ DOWN 1 FROM SUBJECT LOCATE CLASS RIGHT 1 FROM SUBJECT LOCATE TEACHER RIGHT 1 FROM DEPT LOCATE PERIOD DOWN 1 FROM CLASS LOCATE ROOM RIGHT 1 DOWN 1 FROM CLASS LOCATE CON-TROL LEFT 2 FROM STUDENT

Exhibit 4.3: Example 1--Content of the Resulting Transfer File

Exhibit 4.4: Default CA IDMS Schema Mapper Data Structure Diagram

────── 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 ROOM 150, 95 / BB SCHEDULE 150, 12 / BA SPORTS 150, 74 / BB STUDENT 94, 12 / AA SUBJECT 39, 74 / AB TEACHER 94, 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 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 LAST 6 IX-DEPT-NAME SYSTEM (SR7) DEPT 39, 48 / AA IX-DEPT-NAME N MA MODE = INDEX ASC DEPT-NAME DF

Exhibit 4.5: Cross-Reference Report with Default Values