Using Alternate Indexes in Batch pgms: ?
- 2 Answers
- 7023 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 |
What is an alternate index and path ?
I have three fields in a Variable VSAM file X(2) Y(10) occurs X times Z(02) Say for the first record X=2 then the length of the file is 2+(10*3)+2=34 second record, x=4 then 4+(10*4)+2=46 If any time if the field x is updated then the total length changes. Is it feasible? Is it
How do you decide on optimum values for CI, FREESPACE etc...?
What happens when you open an empty VSAM file in a COBOL program for input?
Hi, I want to create alternate index on VSAM file.my file structure is ex: RoomID pic x(7) R000001 Floor pic a((6) First RoomNo pic x(2) FA1 Occupied(yes/no) pic a(3) Yes Occupied Batch pic x(10). Maths i want to create alternate index on floor,roomno fields.can i create alternate index on both the fields.and tell me how to create.
In a KSDS file, key is missing for one record. How to insert the key for that particular record from back up file. Is there any sorting needed for the back up file before the key insertion?
Common VSAM Error conditions and codes
what is vsam catalog ?
what is meant by s0c-07 system abend codes?
What does the keyranges parameter in define cluster command do?
Explain what are the optional parameters to the input dataset while loading the empty cluster with the data records?
Suppose a generation of GDG gets created in a particular step of a proc. How would you refer the current generation in a subsequent step? What would be the disposition of this generation now?
COBOL 
