VSAM – KSDS

  • Post author:
  • Post category:VSAM
  • Post comments:1 Comment

KSDS is known as Key Sequenced Data Set. A key-sequenced data set (KSDS) is more complex than ESDS and RRDS but is more useful and versatile. We must code INDEXED inside the…

Continue ReadingVSAM – KSDS

SQL – Indexes

  • Post author:
  • Post category:SQL
  • Post comments:1 Comment

Indexes are special lookup tables that the database search engine can use to speed up data retrieval. Simply put, an index is a pointer to data in a table. An index in…

Continue ReadingSQL – Indexes

VSAM – ESDS

ESDS is known as Entry Sequenced Data Set. An entry-sequenced data set behaves like sequential file organization with some more features included. We can access the records directly and for…

Continue ReadingVSAM – ESDS

VSAM – Cluster

  • Post author:
  • Post category:VSAM
  • Post comments:1 Comment

VSAM cluster is defined in JCL. JCL uses IDCAMS utility to create a cluster. IDCAMS is a utility, developed by IBM, for access method services. It is used to primarily define VSAM datasets.…

Continue ReadingVSAM – Cluster