why do we use vsam file thn seqential files ?
Answers were Sorted based on User's Feedback
Answer / vijay
1)Record Insertion inbetween the existing recored is
poosible.
Where as in PS file we can add only at the end
2) we read record in any order
were as in PS it is possible to read from 1st , 2nd ,
3rd... like that
| Is This Answer Correct ? | 7 Yes | 1 No |
Answer / rajesh
ps files are stored in tape but esds cannot be stored in tape
and ps file cannot becreated alternate index but esds can be created
| Is This Answer Correct ? | 3 Yes | 0 No |
Answer / pramod reddy
ps files can created on tape.but not esds files.
alternate index can be created in esds.but not in ps.
records inserted in seq nd random.but in ps only seq.
| Is This Answer Correct ? | 1 Yes | 0 No |
what is a Base Cluster?
What is SHAREOPTS ?
In vsam why we use export-import utility?
can alternate index use in ESDS since it does not contain primary index? if yes can you explain?
Would you specify FREESPACE for an ESDS?
How do you define an altindx?
what is the RRN for the first record in RRDS?
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.
Tell about the ams used in vsam?
What is the use Free space in CI ?
is it necessary that all versions of the gdg have to be of the same record length?
is it required that primary key values have to be unique? Do alternate key values have to be unique?