is it slower if you access a record through alternative index as compared to primary index?
- 1 Answers
- 1909 Views
- IBM, I also Faced
- E-Mail Answers
Answer / guru
Yes, because the alternate key would first locate the primary key, which in turn locates the actual record.
| Is This Answer Correct ? | 0 Yes | 0 No |
By seeing a program how we findout it is a VSAM program?
How Vsam was evolved? What was the equivalent file for ESDS,KSDS and RRDS prior to evolution? What were their disadvantages of those file which leads to evolution of ESDS,KSDS and RRDS files ?
Why is it required to have a keyed directed retrieval?
what is buffering and how does it apply to vsam files ?
what is the difference between vsam and dataset how do u create vsam dataset which file you r used?
Create syntax for a VSAM file ?
what is the drawback of vsam dataset?? a.execution slow. b.free space. c.independent storage device. d.none of the above. let me know the answer with reason.
What do you mean by RDW in VSAM?
Do all versions of the GDG have to be of the same record length ? is it possible to ovverride the dcb of the model dataset?
1. delete is not possible in esds. why? 2. i have 10 records in a esds file and i want to delete only 1st record ..then what i have to do?.. it will not affect any sequence of the RBA. 3. why open extend is not possible in rrds vsam file?
What is the use of KSDS,LDS,ESDS,RRDS??what is VRRDS?? How are all these useful in realtime scenario??Plz helpme out...Its a recent question in IGATE..
Define base cluster?
COBOL 
