Using Alternate Indexes in Batch pgms: ?
Answers were Sorted based on User's Feedback
Answer / guest
In the JCL, you must have DD stmts for the cluster and for
the path(s). In the COBOL Program, SELECT .. ASSIGN TO
ddname for base cluster RECORD KEY IS... ALTERNATE RECORD
KEY IS..
Is This Answer Correct ? | 5 Yes | 1 No |
Answer / mani
For every alternate index we define the path.
First we define the base cluster then the alternate index
and then the path.while creating the path we specify the
base cluster and alternate index through which the base
cluster would be accessed.
In order to refer to the alternate index in the jcl we put
two dd statements one for the base cluster and another for
accessing the alternate index which is nothing but the path.
Is This Answer Correct ? | 4 Yes | 0 No |
If FSPC(100 10 is specified does it mean that both the control interval and control area will be left empty because 100 % of both CI and ca are specified to be empty?
explain how many ways you can load data in a vsam cluster?
In the COBOL SELECT statement what is the ORGANIZATION for a KSDS?
How do you convert flat files to VSAM files ?
what is the concept of AIX in vsam ????
What is a lds (linear data set)?
What is free space?
what do you mean by a shareoptions parameter (shr) in define cluster command?
What is the purpose of idcams?
why ci and ca splits are not possible in esds and rrds?
Yes. Because the alternate key would first locate the primary key, which in turn locates the actual record. Needs twice the number of I/Os.
Explain the index set?