Interested to Buy Any Domain ? << Click Here >> for more details...
Using Alternate Indexes in Batch pgms: ?
- 2 Answers
- 8105 Views
- IBM, I also Faced
- E-Mail Answers
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 |
can alternate index use in ESDS since it does not contain primary index? if yes can you explain?
Do primary key values have to be unique? Do alternate key values have to be unique?
What is a path?
What is the COBOL RECORD KEY clause?
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.
Define dynamic processing?
What is the significance of the SHAREOPTIONS parameter?
If we are using empty VSAM file, we can see this empty file by using FILE AID tool. How can we open empty VSAM file if you are using in Program..?
By seeing a program how we findout it is a VSAM program?
What is the purpose of idcams?
explain in brief what are the 3 types of vsam files?
What is a cluster?
COBOL 
