Interested to Buy Any Domain ? << Click Here >> for more details...
What is Alternate Index ? How is it different from regular
index ?
- 2 Answers
- 14985 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 the difference between perform … with test after and perform … with test before?
How do you reference the fixed block file formats from cobol programs
I have program P1 which calls file F1 which has 100 records and following structure 001 .................. 002 .................. 003 .................. 098 .................... 099 ................... 100 .................... Now I want to read these files and write these records in file F2 in following manner. 001 ...... 051 ..... 002 ...... 052 ..... 003 ...... 053 ..... .......... ....... .......... ....... .......... ....... 048 ........ 098 ...... 049 .......... 099 ....... 050 .... 100 ......
How to read the 2nd last record of a VSAM file? (The file size is huge and we don't know the key)
Have you used comp and comp-3 in your project? And how?
how to convert the recors form vsam file to db2 table tru file aid
how do you reference the fixed unblock file formats from cobol programs
How you can read the file from bottom?
What is report-item in COBOL?
Why occurs cannot be used in 01 level in COBOL?
how do you reference the ksds vsam file formats from cobol programs
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)?
What is the difference between Global and External Variables?
Why do we code s9 (4) comp. Inspite of knowing comp-3 will occupy less space?
How you can characterize tables in cobol?
