Let's understand Mainframe
Home Tutorials Interview Q&A Quiz Mainframe Memes Contact us About us

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






© copyright mainframebug.com
Privacy Policy