Previous Topic: Schema Definition SummaryNext Topic: Area and File Considerations


Schema Definitions for VSAM Data Structures

The following table shows the CA IDMS/DB schema definitions for each VSAM data structure type.

CA IDMS/DB schema definitions


KSDS data structure


ESDS data structure


RRDS data structure


Alternate index data structure

Record type and set member

KSDS record definition

ESDS record definition

RRDS record definition

 

Set type

System-owned index

System-owned index

System-owned index

System-owned index

Set order

Sorted on prime key

Sorted on db-key or LAST

Sorted on the added control field

Sorted on the alternate key

Duplicates

Not allowed

Not allowed

Not allowed

Not allowed or LAST

Location mode

VIA indexed set

or other set

CALC prime key

or other field

DIRECT

VIA indexed set

or other set

CALC other field

 

DIRECT

VIA indexed set

or other set

CALC control field

or other field

DIRECT

VIA alternate

key

CALC alternate

key