Interested to Buy Any Domain ? << Click Here >> for more details...
What is Alternate Index ? How is it different from regular
index ?
- 2 Answers
- 14803 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
Write a program that uses move corresponding.
I have File 1 occurs 5 times with Employee-ID,Employee-Name,Employee-Dept (EEE and MECH). I have File 2 occurs 10 times with Employee-ID,Employee-Name,Employee-Dept (EEE,CIVIL,CHEMICAL and MECH). In FIle 1 and FIle 2 , for matching Employee-DEPT (Only MECH) , we need to move entire records from file1 to file 2. We should not use 2D array. Your help is needed here.
For rewrite, why is it mandatory that file needs to be opened?
How did the release of cobol/370 version 1.3 improve the performance of release 1.1?
What are the different types of condition in cobol and write their forms.
How do you reference the fixed block file formats from cobol programs
What is the utilization of copybook in cobol? Could we utilize a similar copybook?
What are the cobol coding sheets?
What is the difference between PIC 9.99 and 9v99 in COBOL?
What is the difference between Global and External Variables?
What are the pertinent COBOL commands?
i was faced one question- i have value -00001234.56 Suppress the zeroes and the output should be -1234.56 But Not - 1234.56 spaces should not be available after suppressing the zeroes. logic in jcl and cobol?
INREC AND OUTREC? HOW TO SPLIT 5K RECORDS TO DIFFERENT FILES IN A FILE IN COBOL? RESTART IN COBOL-DB2? ISOLATION LEVELS?
What is the problem of ordered sequential files access?
How do u write test cases?
