How to do sequential and random reads concurrently

I have an indexed file that I am reading sequentially using a repeating,
non-unique alternate key, using start and read next. Access is dynamic.


As I am reading through this file sequentially, I also have to randomly
retrieve records from the same file using the primary key. (For each
record that I retrieve sequentially, I have to get another record
randomly.)

I can't do a start after the random read to reset the record pointers
for the sequential read, because I am using a non-unique alternate key
to start the sequential read.

How do I do this without messing up the record pointers? When I tested
this, I don't get all the records I should get from the sequential read,
as if the random read 'resets' the record pointers.

How do I get around this? Thanks in advance for your help!

Nancy Barney
Dakota Drug, Inc