What is Alternate Index ? How is it different from regular
index ?
- 2 Answers
- 13869 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 are the different rules to perform a Search?
How to remove 2 duplicate records and copy only one using job control language?
) How do u handle errors in BMS macro?
What is perform what is varying?
Define cobol?
How can i load all the data from a file to Table (array) in cobol.How i manage the occurs clause with out reading the file.Any options avilable ? Please can any one help me it is urgent?
In COBOL programming, what is PERFORM? What is VARYING?
how do you reference the variable unblock file formats from cobol programs
here is my requirement A1 is alphanumeric with value 'A1B2C3D4' as defined below 05 A1 PIC X(8) VALUE IS 'A1B2C3D4' but i need to have A2,A3 as ABCD & 1234 repectively...... A2 = ABCD A3 = 1234 Can you please explain me what are the different ways to do it?
Have you used the sort in your project?for this type of questions any working on real time project give the eg. with real time scenario.
What is the difference between comp and comp-3?
please..could u give an example about USAGE IS POINTER ..and explain why and when we use it ?
Explain the configuration section of a cobol program with examples of syntax.
what is the difference between COBOL2 AND COBOL390?
Is it possible that the redefines clause has different picture clauses compared to the one it redefined?
