Summary -

In this topic, we described about the Build Index with detailed example.

The last step is build index for the alternate index. The build index step will build index for the alternate key by verifying the records with primary index and creates the corresponding alternate index for each primary index. In other words, Build index performs the load operation after the alternate index defined.

Syntax -

///JOB CARD
//*------------------------------------------------------------------
//* Define unique AIX
//*------------------------------------------------------------------
//STEP01  EXEC PGM=IDCAMS
//SYSPRINT  DD SYSOUT=*
//SYSIN     DD *
    BLDINDEX -
        INDATASET(userid.KSDS.CLUSTER) -
        OUTDATASET(userid.KSDS.ALTIDX)
/*