Re: Last record written

["Prevesh Kuni" <KuniP@xxxxxxxxxxxxx>]

Thanks, Rob, Joe and Peter for the replies,
Our files are not journelled and sorry Joe but I need to check an
existing file but will take the advice on the timestamp field when
creating files from now on - thanks!
 
Prevesh Kuni
RPG Developer
Smollan Group SA (Pty) Ltd
(011) 640 8154 
kunip@xxxxxxxxxxxxx 


> > > joepluta@xxxxxxxxxxxxxxxxx 2008/05/06 03:52:46 PM >>>
Prevesh Kuni wrote:
> Hi Guys,
>
> Is there a way to determine when the last record of a file was
> written?
Prevesh, I don't know if this is an option for you, but this is a 
favorite technique of mine: I add a timestamp field called "written" to

the physical file. Make sure it is NOT NULL capable. Then create a 
logical view over the file that does not include the timestamp field. 
If you write a record to the logical, it will automatically initialize

the timestamp field to the date/time the record was written.

Joe