Re: Reusing deleted records

At 01:12 AM 9/20/98, you wrote:
>Al,
>
>At 08:29 PM 9/18/98 -0400, you wrote:
>
>>Note than when the file is opened, the system develops a "deleted record
>>map".  This is an internal table of available deleted records to be re-used
>>by RR number.  If another application subsequently deleted a record, the
>>first application is not aware of the newly deleted record.
>
> I haven't inventigated this, but your explanation doesn't sound right to
>me.  Figuring out where a new record should go is data management's job,
>not the RPG program's.  So the record should be able to end up in a newly
>available space.
>
You are correct.  When a file that specifies REUSEDLT(*YES) is opened, as a
part of the open, OS/400 develops the deleted records map.  When a record
is added under that file open OS/400 consults the deleted records map for
the RR# of where to add the record.  When all deleted records have been
exhausted, only then are new records added at the end of the file.  If
another job opens the file later and deletes a record, the first job will
not know about the newly deleted record until the file is closed and reopened.

Al




+--------------------------------------------------+
| Please do not send private mail to this address. |
| Private mail should go to barsa@ibm.net.         |
+--------------------------------------------------+

Al Barsa, Jr. - Account for Midrange-L
Barsa Consulting, LLC.  
400 > 390

Phone:  914-251-9400
Fax:    914-251-9406


+---
| This is the Midrange System Mailing List!
| To submit a new message, send your mail to MIDRANGE-L@midrange.com.
| To subscribe to this list send email to MIDRANGE-L-SUB@midrange.com.
| To unsubscribe from this list send email to MIDRANGE-L-UNSUB@midrange.com.
| Questions should be directed to the list owner/operator: david@midrange.com
+---