RE: LAST record

["Wilt, Charles" <CWilt@xxxxxxxxxxxx>]

Dave,

This works the same even if "reuse deleted records" is *NO?

What about reading?

I assumed there were ways to read/write to deleted records, ala the various 
undelete utilities. But I figured an API or MI program would be involved.

Very interesting, Thanks!

Charles Wilt
iSeries Systems Administrator / Developer
Mitsubishi Electric Automotive America
ph: 513-573-4343
fax: 513-398-1121
 

> -----Original Message-----
> From: midrange-l-bounces@xxxxxxxxxxxx
> [mailto:midrange-l-bounces@xxxxxxxxxxxx]On Behalf Of Dave Schnee
> Sent: Friday, May 06, 2005 3:07 PM
> To: midrange-l@xxxxxxxxxxxx
> Subject: Re: LAST record
> 
> 
> 
> 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>
>