Re: Last record written

["Prevesh Kuni" <KuniP@xxxxxxxxxxxxx>]

Thanks Neil, gonna have a look at it and keep you informed...
 
Prevesh Kuni
RPG Developer
Smollan Group SA (Pty) Ltd
(011) 640 8154 
kunip@xxxxxxxxxxxxx 


> > > neilpalmer400mr@xxxxxxxx 2008/05/07 10:31:12 AM >>>
Prevesh,

If you're looking solely for when the last record of a
file was written (not any specific record) then maybe
you could use DSPOBJD on the file and check the change
date (in an outfile fields ODLCEN, ODLDAT & ODLTIM). 
Of course if records in the file are modified after
they are written then you will only get the date &
time of the last update.

...Neil

--- Prevesh Kuni < KuniP@xxxxxxxxxxxxx > wrote:

> Thanks, Rob, Joe and Peter for the replies,
> Our files are not journalled 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
> -- 
> 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 .
>
>
> -- 
> 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 .


Neil Palmer, Cambridge, Ontario, Canada

(This account not monitored for personal mail,
remove the last two letters before @ for that)


__________________________________________________________________
Be smarter than spam. See how smart SpamGuard is at giving junk email
the boot with the All-new Yahoo! Mail. Click on Options in Mail and
switch to New Mail today or register for free at http://mail.yahoo.ca