CA IDMS/DB Schema and VSAM File Correspondences › Relative-Record Data Set › Example of Schema Definition

Example of Schema Definition

The DDL statements necessary to represent a VSAM RRDS department record in the CA IDMS/DB database might be as follows:

        ADD RECORD NAME IS DEPARTMENT
            LOCATION MODE IS VIA DEPARTMENT-NDX SET.

        ADD SET NAME IS DEPARTMENT-NDX
            ORDER IS SORTED
            MODE IS INDEX
            OWNER IS SYSTEM
            MEMBER IS DEPARTMENT
               ASCENDING KEY IS CONTROL-FIELD
                  DUPLICATES NOT ALLOWED.