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!!

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.

wht do u mean by (*,intrdr) wht is * used for ?

2 Answers  

---

We are using the searching a table which is indexed, once the key is found, how can we get the occurance at which the key was found.

1 Answers  

---

How can we increase the size of an existing PDS to include more no. of modules.

3 Answers  

---

I have 100 records in a file.. i want to sort the records from 5 to 5o... give the syntax...

2 Answers   CTS, DSRC,

---

What is CALL statement in COBOL?

4 Answers  

---

How will 128 be saved in s9 (3) comp-3 How will 12 be saved in s9 (2) comp

3 Answers   CTS,

---

how to convert the recors form vsam file to db2 table tru file aid

0 Answers   TCS,

---

i want to enter the name 'pandu' into ur table how?

1 Answers   Fidelity,

---

What does the IS NUMERIC clause establish ?

2 Answers  

---

What is the significance of 'above the line' and 'below the line'?

2 Answers   Nokia,

---

How to retrive the 9th records out of ten records using the cobol program ?

3 Answers   UST,

---

What is the size of s9(19)comp3? explain

8 Answers  

---