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.

if i am reading a file with some 50000 records and moving to a DB2 table and suddenly the program abends in between, is there anyway i could restart from the exact record at which the job failed once the program restarts.

2 Answers   UST,

---

which certifications r 4 cobol,jcl,db2,cics what is format of xam n what is importance of these certifications... plz post answer only if u r sure... thanks

1 Answers  

---

1.What is the default print format in cobol?

5 Answers   HSBC,

---

how will u code parm parameter and where pls ?

3 Answers   DELL,

---

Which is the best IBM mainframe Training Institute in Ameerpet, Hyderabad

35 Answers  

---

What is difference between comp & comp-4?

6 Answers  

---

1.give the details about WHEN OTHER. 2. how many form are available in evaluate.

0 Answers   IBM,

---

what is the difference between COBOL2 AND COBOL390?

0 Answers   L&T,

---

what is srange and nosrange pls reply to ths question ?

2 Answers   L&T,

---

What is perform what is varying?

0 Answers  

---

When is inspect verb is used in cobol?

0 Answers  

---

how do u indetify files succesfully executed or not ?

4 Answers   TCS,

---