Re: LAST record

[Dave Schnee <DSchnee@xxxxxxxxxxxxxxxxxxx>]

Charles Wilt wrote:

----------------------------------------------------------------------

message: 1
date: Fri, 6 May 2005 12:53:31 -0400
from: "Wilt, Charles" <CWilt@xxxxxxxxxxxx>
subject: RE: LAST record

Or use *END...

      *END    setll  MyFile
              read   MyFile 


BTW Dave, care to share how you explicitly control writing to deleted 
records?

AFAIK, if reuse deleted records is set the RDBMS controls when the deleted 
records is reused.

----------------------------------------------------------------------

Charles:

You're right, if you specify "reuse deleted records", the RDBMS controls 
reuse, but you can control it yourself and, if you do so (or the RDBMS 
does so) then the most recent record may not be at the end of the file in 
sequential access mode.

It is surprisingly easy to write over a deleted record's space, but you 
need to know, in advance, where the deleted records are.  Here's a sample 
in RPGLE:

<code>
0001.00 h

0002.00 ftestfile2 uf a e             disk    recno(rec#)
 
0003.00 d rec#            s              5i 0 

    (somehow, magically, put a deleted record's record number into "rec#")

0018.00 c                   write     testrec
</code>

Dave Schnee,
Barsa Consulting Group, LLC.