CA IDMS/DB Schema and VSAM File Correspondences › Entry-Sequenced Data Set › Examples of Schema Definition

Examples of Schema Definition

Sorted Set

The DDL statements necessary to represent a VSAM ESDS employee record in the CA IDMS/DB database as a sorted set might be as follows:

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

     ADD SET NAME IS EMPLOYEE-NDX
         ORDER IS SORTED
         MODE IS INDEX
         OWNER IS SYSTEM
         MEMBER IS EMPLOYEE
            ASCENDING KEY IS DBKEY.

Unsorted Set

The DDL statements necessary to represent a VSAM ESDS employee record in the CA IDMS/DB database as an unsorted set might be as follows:

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

     ADD SET NAME IS EMPLOYEE-NDX
         ORDER IS LAST
         MODE IS INDEX
         OWNER IS SYSTEM
         MEMBER IS EMPLOYEE.