can alternate index use in ESDS since it does not contain
primary index? if yes can you explain?
Answers were Sorted based on User's Feedback
Answer / reji
Alternate index is possible. There is no relation between
primary index&alternate index
Is This Answer Correct ? | 10 Yes | 1 No |
Alternate index is possible in ESDS but only in
On-line mode using RBA (Relative Byte Address)
- Accessing of records through RBA is faster than
accessing through index field
- It can be dangerous, since RBA can be altered
through control interval/control area split
Is This Answer Correct ? | 1 Yes | 0 No |
Answer / sridhar
Alternate index can be used only in KSDS and ESDS.primary
index is not available in ESDS,it has RRN(relative record
no)only.
Is This Answer Correct ? | 0 Yes | 8 No |
What is the maximum no. of records that can be allowed in VSAM ?
Explain the catalog?
what is the use of the file status clause in the select statement in vsam?
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
Can we copy Vsam files from a Vsam file in Iebgener step?
4 Answers iGate, Tech Mahindra,
Do primary key values have to be unique? Do alternate key values have to be unique?
we can define the ksds cluster by two ways by using the file-aid or by using the idcams utility. Explain them.
What is a ca split?
print ids(/)char??what is the full form of ids??
should a AIX should be a unique value?
How are records stored in an ESDS, entry sequenced dataset?
Differentiate between control interval (ci) and control area (ca)?