Follow Our FB Page << >> for Daily Laughter. We Post Funny, Viral, Comedy Videos, Memes, Vines...

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

) How do u handle errors in BMS macro

0 Answers   IBM,

I have a table with 3 dimensions like this : 01 ws-table 04 ws-page occurs 3 08 ws-column occurs 2. 12 ws-record occurs 20 pic x(40). How to code with PERFORM varying with 3 dimension...I forgot..

2 Answers   EDS,

A cobol program to read a file , match it with other if. If match occurs then write it to an output file. If no match then no need to write it.Error log created by program to track any error.

1 Answers  

study the following code 01 A1 05 B PIC 99 05 C PIC X(4) 01 A2 05 B PIC 99V99 05 C PIC A(4) pick out the valid statement from the following a.A1 and A2 can not have sub-ordinates b.A1 and A2 can have the same sub-ordinates but must have same PIC clause c.there is nothing wrong d.A1 and A2 can have same sub-ordinates provided they are not at 01 level

4 Answers   TCS,

plz any one tell clearly the justify right clause?

1 Answers  

what is a zoned decimal data type and how it will be stored?

2 Answers   IBM,

What is an in-line perform ?

4 Answers   Accenture,

how you read control card into array?

3 Answers   HCL,

What are the different rules of SORT operation?

0 Answers  

Can we dynamically increase the size of occurs clause? i.e In case I an not sure of the size of array and want to increase the size at run time.If yes , how?

1 Answers  

Size of a column has been changed in DB2 table (Suppose it was of 5 characters and later changed to 4 characters) and forgot to change the DCLGEN in COBOL program, what will happen during the execution of code? If the program Abends then what will be the error? If it doesn't abend then hpw the error can be catched?

5 Answers   IBM,

At the minimum, which division of COBOL is enough to be coded?

3 Answers   CTS,