Interested to Buy Any Domain ? << Click Here >> for more details...
What is Alternate Index ? How is it different from regular
index ?
- 2 Answers
- 14825 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
How to use the same COBOL program in Batch and CICS on lines? explain with an example
What is the utilization of copybook in cobol? Could we utilize a similar copybook?
what happens if parmparameter passes zero bytes to the program
What are different data types in cobol?
Differentiate cobol and cobol-ii. (Most of our programs are written in cobolii, so, it is good to know, how, this is different from cobol)?
How to read the 2nd last record of a VSAM file? (The file size is huge and we don't know the key)
What is Pic 9v99 Indicates in COBOL?
What is the difference between binary search and sequential search?
What is the difference between PIC 9.99 and 9v99 in COBOL?
How do you code cobol to access a parameter that has been defined in jcl? And do you code the parm parameter on the exec line in jcl?
1.Is it possible to move the data from 99.99 to 99v99? 2.What is the CICS-vsam Compilation process? 3.In My GDG 5 generation will be there GDG3 got an abend what will happen? 4.In my GDG first generation is +1 And I want to add the new generation what will happen previous generation? 5.How can you give the PIC clause below conditions A). s9 (reddy), B). s9 (5) occurs 5 times? 6.How override the proc from a particular step? and what is symbolic and override Procs?
Which is the default, TEST BEFORE or TEST AFTER for a PERFORM statement?
how to access the file from prodution from changeman tool and to submit a file to production
How do u write test cases?
I have a File that has duplicate records. I need only those records that occur more than thrice.?
