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

A maximum of 100 chars can be passed to Cobol through Parm in JCL, If we want to pass more than 100 Chars how we can do it ?

4 Answers   IBM,


What is the function of dd name parameter with a 2 part structure; audit.report?

0 Answers  


can anyone explain me about sort in jcl with inrec and outrec ?

2 Answers   HCL,


Is automatic restart possible in jcl?

0 Answers  


When you specify multiple datasets in a JOBLIB or STEPLIB, what factor determines the order?

0 Answers  






What type of versions we r using in mainframe (jcl, cobol, db2, vsam, cics)?

1 Answers   Accenture,


A job has 150 steps i want to execute only 57th step

3 Answers   Cognizant,


How can values be passed from the job stream to an executable program?

0 Answers  


consider the following progrm statements MOVE 0 TO SW.NO.OF.REC PERFORM PRI-OUT UNTIL SW=1 DISPALY NO.OF.REC STOP RUN PRE-OUT READ IN-FILE AT END MOVE 1 TO SW WRITE OUO-REC FROM IN-REC ADD 1 TO NO.OF REC if the IN-FILE contains 1000 records what value will be displayed after the PERFORM is over? assume that N0.OF.REC has PIC 9(4) a.1000 b.1001 c.1 d.none of the above

1 Answers  


What is the purpose and meaning of the TIME keyword and what JCL statement is it associated with?

1 Answers  


Can we use empty VSAM as input?

9 Answers   Convergys, Kanbay,


What is the DD statement for a output file?

3 Answers  


Categories