What is Alternate Index ? How is it different from regular
index ?

Answer Posted / vish

The answer provided by NK is absolutely correct but we
should be very careful whil choosing the alternate index as
it may not be Unique. e.g. in the example given by NK, the
Emp# will always be Unique within a company but many many
employees can have the same name. So if we declare Emp_name
as AIX (i.e. alternate Index) and then use it for fetching
data then we may end up in multiple rows and hence we may
need additonal logic to arrive at the desired unique record.

Your comments are Welcome!!

Is This Answer Correct ?    14 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What is the default value(s) for an initialize and what keyword allows for an override of the default?

703


What are the different open modes available in cobol?

726


if we display var1 then what will b displayed in below condition. 77 var1 pic s9(2) value -10. 77 var1 pic s9(2) value -11. " " " -12. " " " -13. -14 ... ... -19.

5708


How to fetch 1000 error records from VSAM file(Eg: 1000000 records present) while getting SOC7 abend ?

1975


What is Pic 9v99 Indicates in COBOL?

735






can anybody post me about file-aid and changemen tools pls and give me reference if any mainframe guys are there

1915


Have you used comp and comp-3 in your project? And how?

2014


can you please let me know if there is any walkins for COBOL/PLI/DB2/IMS/JCL in pune other than IBM and ITC infotech

1966


What are literals?

638


INREC AND OUTREC? HOW TO SPLIT 5K RECORDS TO DIFFERENT FILES IN A FILE IN COBOL? RESTART IN COBOL-DB2? ISOLATION LEVELS?

433


how do you reference the ksds vsam file formats from cobol programs

673


) what is the difference between AID and HANDLE AID?

1641


What is the difference between a binary search and a sequential search? What are the pertinent cobol commands?

725


What are all the divisions of a COBOL program?

667


Difference between cobol and cobol-ii?

719