CA IDMS/DB Schema and VSAM File Correspondences › Key-Sequenced Data Set › Record and Set Representations

Record and Set Representations

In an CA IDMS/DB database, a KSDS data set corresponds to a system-owned indexed set sorted on prime key. To represent a VSAM KSDS in an CA IDMS/DB database, you must include the following definitions in the schema:

• A record type whose description corresponds to the KSDS record
• An indexed set whose owner is SYSTEM and whose member record is the record type described above
• A set order of SORTED (on the prime key)
• A duplicates option of DUPLICATES NOT ALLOWED