MVSFORUMS.com

[mayuresh.tendulkar]

Hello All,

I have one query, My Alternate index is having about 1,00,000 records (with duplicates) and I want to update those duplicate records with some information.

Currently I am doing the following procedure to do it:

1) Browse the file using STARTBR
2) READNEXT with the Key.
3) Get the pointer and ENDBR the file
4) Again READ the record with UPDATE and then REWRITE the record

Here I am reading the record twice.

What I wanted to ask is, Is there any optmized way of doing this?

Thanks
Mayuresh Tendulkar