what is alternate index?



what is alternate index?..

Answer / bhakti

It is used whenever data needs to be retrieved on the basis
of the other fields i.e. other than primary fields.
Supported by KSDS and ESDS only but not by RRDS and LDS
because they do not have any index component.
Not more than 253 AIX (Alternate Index) can be specified.
AIX is composed of Primary key record along with the field
identified as secondary key.

Is This Answer Correct ?    3 Yes 0 No

Post New Answer

More JCL Interview Questions

We are aware of eliminating the duplicate records from outyput fiel using sort utility. Can we get the duplicate records in to another file in the Same sort utility?

2 Answers  


i want to see the jobs in skeleton queue in diff region. (eg. 7 regions are running means , i want to see all the jobs in 7 regions which are in skel queue using 1 command)

1 Answers  


If we have 100 job steps in JCL and we want to excute steps only starting from 43 to 50, then how it can be coded in JCL/

10 Answers   IBM,


What is the exact difference between PRTY and DPRTY

2 Answers   iGate,


how you can direct the data to spool using SYSOUT option?

0 Answers  






if we give TIME=0 how many sec that job/step

14 Answers  


how are instream data terminated?

3 Answers   Tech Mahindra,


Can we use COND=EVEN on a job card, when jobs are scheduled through scheduler?

5 Answers   L&T,


how to have variable length record in outrec..i have the requmt as follows.. i/p file variable lenght record output file : i need to alter the input and write into outrec(another file) sort fields: copy from(dd1) using ctl1 ctl1cntl dd * outfil fnames=xxx, outrec=(1,131) here i outrec is bombing with error..how to overcome this defect...???

1 Answers  


How to find out the number of records in a file using JCL

5 Answers   CTS,


What is primary allocation for a dataset?

4 Answers  


One of My Job is running in production, which contains five steps?i want to pass the input to FIFTH step while running is it possible? if how?

1 Answers   CTS,


Categories