How many Alternate Indexes you can have on a dataset?
Answers were Sorted based on User's Feedback
Answer / sivakumar devaram
253.but not more than 5 recommended because of overheada in
storing and maintaining alternate indexes.
| Is This Answer Correct ? | 15 Yes | 2 No |
Answer / guest
255 - but you must be a nut to have so many ALT Indexes on a
dataset!
| Is This Answer Correct ? | 7 Yes | 6 No |
how to see the last records in vsam dataset??
Why is master catalog used in vsam?
The first VSAM file V1 has 2 fields A and B . There is a DB2 file which has fields E and f. We need the fields A, B , E and F to another VSAM file called V2. Kindly mention the logic in procedure division in cobol..
What does the keyranges parameter in define cluster command do?
Explain the index set?
Explain the difference between lds and esds?
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.
How do you load a VSAM data set with records ?
what how do you initialize a vsam file before any operation? A vsam with alternate index?
What does the keyranges parameter in define cluster commends do?
what do you mean by idcams? Explain its purpose?
How do you convert flat files to VSAM files ?