Joined: 23 May 2003 Posts: 11 Location: Chennai, India
Apart from access through primary key,VSAM provides use of upto 255 alternate keys per dataset.
With in the KSDS (or) ESDS retriving a data other than the unique key,with in alternate index key duplicate data are allowed.
creation of alternate index using the IDCAMS utility there will be three steps
1.DEFINE AIX --> is used to create an alternate index for the field.
2.DEFINE PATH --> it is used to create a path between your main index and AIX.
3.BUILD INDEX -->Once an AIX has defined, records can be loaded into it using the BLDINDEX command.