what is the use of aix in vsam why do we go for aix and wht
is build index in vsam?
Answers were Sorted based on User's Feedback
Answer / guest
aix is the secondary key for searching the records in the
cluster.aix must be duplicate r unique..
Is This Answer Correct ? | 17 Yes | 0 No |
Answer / codebulls
At times a vendor might offer a file to be consumed by a mainframe application. Rather than the primary key, the file would contain another field in the VSAM which is unique but not the primary key of VSAM. If such fields are made to be Alternate Index, unnecessary reads and performance overhead can be avoided.
Is This Answer Correct ? | 0 Yes | 0 No |
Answer / sanjana
we use aix to reduce the fields in base table.in further
divided tables will have their own primary key for each
table.in this way we can search the records in the cluster
very easily.
Is This Answer Correct ? | 2 Yes | 6 No |
Hi...........
we use AIX to extend the limit of Keys.
Suppose i have following records with key(5,0)
00001 Ravindra Uttaranchal
00002 Reena Uttaranchal
And We got new records from Client as following
00001 Manmohan New Delhi
00002 Gaurav New Delhi
So there may be confliction
To resolve this we create AIX on KSDS/ESDS.
Thanks & Regards.
Is This Answer Correct ? | 1 Yes | 9 No |
What makes vrrds different from vsam?
What is the purpose of the FILE STATUS clause in the SELECT statement?
What happens when you open an empty VSAM file in a COBOL program for input?
What is a ca split?
explain in brief what are the 3 types of vsam files?
what are the additional information you should give in the dd statement while defining the next generation of a gdg?
What is an RBA in rrds? What does it do? What is it used for?
In the COBOL SELECT statement what is the ORGANIZATION for a KSDS?
What are the types of VSAM datasets?
Do all versions of the GDG have to be of the same record length ?
How do you fix the problem associated with VSAM out of space condition?
print ids(/)char??what is the full form of ids??