Re: Logical file keyed by active RRN

As I understand it, you are simply trying to retrieve the records in the
same order they were written.

The key doesn't have to be the RR#. It could just be a sequence number or
even a date and time stamp. If you really do need the RR# you can obtain
that after you read the record. 

You could then reuse deleted records, which would make your physical file
smaller.

----- Original Message -----
From: "David C. Shea"
To: midrange-l@xxxxxxxxxxxx
Subject: Logical file keyed by active RRN
Date: Fri, 22 Jul 2005 11:37:01 -0400

>
> I want to create a logical file where the key is RRN. I only want
> active records listed in this logical.
>
>
>
> The goal here is to be able to SETLL by key of RRN and have the pointer
> positioned either at the next record in the file or EOF.
>
>
>
> This is for a situation where there could be millions of deleted
records
> in the file. Doing a regular SETLL by RRN and a READ could end up
> scanning thru millions of deleted records.
>
>
>
> Doing a SETLL on a logical file _keyed_ by RRN might do the trick.
>
>
>
> Any thoughts??
>
>
>
>
>
>
>
> --
> This is the Midrange Systems Technical Discussion (MIDRANGE-L) mailing
list
> To post a message email: MIDRANGE-L@xxxxxxxxxxxx
> To subscribe, unsubscribe, or change list options,
> visit: http://lists.midrange.com/mailman/listinfo/midrange-l
> or email: MIDRANGE-L-request@xxxxxxxxxxxx
> Before posting, please take a moment to review the archives
> at http://archive.midrange.com/midrange-l.