Module 4: Alternate INDEX
Defining Path
- IDCAMS command ‘DEFINE PATH’ is used to relate VSAM base cluster and an alternate index.
- Syntax:-
DEFINE PATH( - NAME(alternate-index-path-name) - PATHENTRY(alternate-index-name))
Where, NAME, is used to specify the Alternate Index (AIX) Path name and PATHENTRY is used to specify the AIX name
Example
Defining path
//DEFNPATH EXEC PGM=IDCAMS
//SYSPRINT DD SYSOUT=*
//SYSIN DD *
DEFINE PATH( -
NAME(PAYT.PAY.KSDSAIX.PATH) -
PATHENTRY(PAYT.PAY.KSDSAIX))
/*
- In CICS, if you want to access base cluster with alternate key, then you should register the PATH as FCT entry
- Note: The order of build index and path definition does not matter