Re: RRN question

[Joep Beckeringh <joep@xxxxxxxxxxxxxxxxxxx>]

Mike,

Apart from the comments Scott and Buck already made: if the logical is not 
unique, there is no guarantee that you get the records for a certain key in a 
particular sequence. Thus, if you get RRN's 1, 2, 3, 4, 5 for a key the first 
time, you might get 3, 5, 1, 4, 2 the second time.

You write that you cannot the change the logical to a uniquely keyed one. Is 
that because you cannot change the logical at all? Otherwise it should be no 
problem to extend the key with another field that makes it unique.

Joep Beckeringh


Mike Silvers wrote:

> All,
>
> We have a situation where we need to set a file to a specific pointer
> location and reads according a key list from that point on.  I have reviewed
> the archives and found multiple questions about this same situation, but
> there were no real resolutions to those questions.  Lets see if anyone has
> any other ideas.  Here is the situation:
>
> I have a logical file that is not uniquely keyed.  We are not able to change
> to a uniquely keyed file.
> We read the file and stop on a specific record.  The RRN is returned to the
> calling program.
> At another time, the program is called with the keys and the RRN again.
> We need to start at the record where we stopped before and continue reading.
>
> Does anyone have a recommendation on an efficient method to accomplish this
> task?
>
> Thanks
>
> Mike