Field descriptions for the Cross-Reference Report (Exhibit 3.4) are described below:
RECORD NAME field contains the REC-NAME of each record block in the CA IDMS Schema Mapper data structure diagram.
LOCATION field contains the location of each record block in the diagram, given by coordinate position.
PAGE field contains the location of each record block in the diagram, given by page identifier.
SET NUMBER field contains the unique number assigned to each set and index in the diagram.
SET OR INDEX NAME field contains the SET-NAME of each set and index in the diagram.
OWNER field contains the OWNER record names for each set. Integrated indexes are labeled SYSTEM(SR7).
LOCATION field contains the locations of the OWNER records, given by coordinate position.
PAGE field contains the location of OWNER records, given by page identifier.
MEMBER field contains the record names for each set and the following: the set name, set linkage options (N for next pointers, NP for next and prior pointers, NO for next and owner pointer, or NPO for next, prior, and owner pointers), disconnect and connect options (MA for mandatory automatic, MM for mandatory manual, OA for optional automatic, or OM for optional manual), and the order in which new records are positioned in the set (FIRST, LAST NEXT, PRIOR, or sorted).
LOCATION field contains the locations of the MEMBER records, given by coordinate position.
PAGE field contains the locations of the MEMBER records, given by page identifier.
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 3.4: Sample Cross-Reference Report
|
Copyright © 2013 CA.
All rights reserved.
|
|