Re: Last record written

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