VSAM - Alternate Index

In this video, I have explained how to define the alternate index in mainframes. I have manually typed the code along with input and output files for the reference. Please use the example to create alternate index. If you like the video, please subscribe and like the video. Share our channel IIWOWIIS with your friends. Thanks all for your support. Alternate index(AIX) provides access to records by using one or more than one key field. AIX key can have duplicates. It can be defined for both KSDS and ESDS. AIX is mostly used whenever the data is required to be retrieved on the basis of additional key field (other than the primary key field). Steps to create an Alternate Index Define cluster Define Alternate Index using the cluster Define Path Building Index //SYSIN DD * DEFINE AIX (NAME(HLQ.MYVSAM.KSDS.AIX) - RELATE(HLQ.MYVSAM.KSDS) - CISZ(4096) - FREESPACE(2043 16300) - KEYS(1,10) - UNIQUEKEY - UPGRADE - RECORDSIZE(80,80)) - DATA(NAME(HLQ.MYVSAM.KSDS.DATA)) - INDEX(NAME(HLQ.MYVSAM.KSDS.INDEX)) /* Example to define a path: DEFINE PATH - NAME(HLQ.MYVSAM.KSDS.PATH) - PATHENTRY(HLQ.MYVSAM.KSDS.AIX)) - UPDATE/NOUPDATE) Example of Build index: //SYSIN DD * BLDINDEX - INDATASET(HLQ.MYVSAM.KSDS) - OUTDATASET(HLQ.MYVSAM.KSDS.AIX)) /*