Interested to Buy Any Domain ? << Click Here >> for more details...
What is Alternate Index ? How is it different from regular
index ?
- 2 Answers
- 14896 Views
- I also Faced
- E-Mail Answers
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
What is difference between static and dynamic call in cobol?
HOw can I get the negative sign while deduct high value from low value
What rules are to be followed while using the corresponding options?
What are the different rules for performing sort operation?
If you are current on the owner of a set, what is the difference between obtain next and obtain first?
Why do we code s9 (4) comp. Inspite of knowing comp-3 will occupy less space?
Why would you use find and get rather than to obtain?
How do define dynamic array in cobol.
Write a program to explain size error.
What is the Purpose of POINTER Phrase in STRING command in COBOL?
What are declaratives and what are their uses in cobol?
What are all the divisions of a COBOL program?
please..could u give an example about USAGE IS POINTER ..and explain why and when we use it ?
what is amode(24), amode(31), rmode(24) and rmode(any)?
2 input fles: 2 flat files, with different number of records. both are having unique key for each record and already sorted in ascending order . match these files using unique key and in output only matching key value has to be written. please procide cobol logic
