What is Alternate Index ? How is it different from regular
index ?

Answers were Sorted based on User's Feedback



What is Alternate Index ? How is it different from regular index ?..

Answer / 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

What is Alternate Index ? How is it different from regular index ?..

Answer / nk

The purpose of any index is to provide the most efficient
access to the records in a file. Say you have a file of
employee names and numbers. Usually the primary index will
be the employee number. If you request a record by
providing the empl#, the access will be very fast. If you
have to very often request a record by the empl name, you
may want to create a second (a/k/a alternate) index based
on the name. So when you provide a name, the access to the
correct record also will be very fast.

Is This Answer Correct ?    10 Yes 2 No

Post New Answer

More COBOL Interview Questions

wht happens if we dnt give scope terminator ?

4 Answers   TCS,


can u give result for the fallowing example... 05 a pic 9(2) 05 b redifines a pic x(2). move 'xy' to b. display a,b.

10 Answers   IBM,


1)what is use of linkage section? 2)what is difference between comp and comp-3

1 Answers   Cap Gemini,


What is the difference between PIC 9.99 and 9v99?

7 Answers  


we can use set true for condition names.. similarly can we code set to false in cobol pgm? will it work?

1 Answers  






WE HAVE 2 FILES IN COBOL. ONE IS FIXED LENGTH RECORDS ANOTHER ONE IS VARIABLE LENGTH. IF I DECLEAR LRECL OF FIXED ONE AS 80 AND 2ND RECORD AS 132. WHAT WE NEED TO DECLEAR LRECL FOR THOSE 2 FILES IN JCL?

4 Answers   iGate,


how do you reference the variable unblock file formats from cobol programs

0 Answers  


hi friends,can any one post the ibm mainframe inteqview questions for 1year exp candidate,for itc infotech interview?. have any body attended for this in the past?...

1 Answers   ITC Infotech,


.How to add one input & one Out file in existing cobol program. how approach tell me step by step.

2 Answers   Syntel,


What are the divisions in a cobol program? Which one is the mandatory division among them?

1 Answers  


I have 2 dimensional array with having 100 elements. So how to find the 11th item in an array?

6 Answers   IBM,


where did you see the information regarding abend codes in jcl?

1 Answers   Hewitt,


Categories