Re: Get Record Creation Date

William

Sorry, but there is absolutely no record of when a record is added to a file.

Henrik mentioned adding a trigger - you did not address that - in fact, that might be a good solution for the future - it requires no change to the files themselves.

The trigger could write a record to a log of sorts - that log could contain the library and file name, as well as the RRN for each record as added, along with a timestamp.

As to the past, there is nothing in any language or process - the information simply does not exist.

I do challenge the idea that journaling can't be done - - the trigger idea is basically doing what journaling does - this does not require that you start using commitment control - all you need is the before image, I think, on a write. Of course, you would probably need to keep the journal receivers around perpetually, to keep the history - this suggests some kind of compression of journal entries in which you have no interest.

HTH
Vern

On 1/5/2014 7:57 AM, William Salim wrote:

First of all, there are no journals and files cannot added new fields..
Files used by many old programs that strictly cannot changed and do those
two things (journal and add field).
Bad design but need alternative solutions..

Thanks
On Jan 5, 2014 8:48 PM, "Henrik Rützou" <hr@xxxxxxxxxxxx> wrote:

As suggested - add a creation data field to the record

or ...

journal the file

or

add a trigger program that records when records are added


On Sun, Jan 5, 2014 at 2:31 PM, Bill Wragg <bill_wragg@xxxxxxxx> wrote:

Only solution is to add a date field to the record and when it is created
populate it with the date.

Good Luck

-----Original Message-----
From: rpg400-l-bounces@xxxxxxxxxxxx [mailto:

rpg400-l-bounces@xxxxxxxxxxxx]

On Behalf Of William Salim
Sent: January-05-14 7:17 AM
To: rpg400-l@xxxxxxxxxxxx
Subject: Get Record Creation Date

Hi Everyone..

I look something that RPG or Any other language can have the capability

to

get the creation date for the record that has been created in files
(PF/LF).

i have try to do the exploration using the QDBRTVFD but still no result,
the
API only gave the last updated files not record.

is there any solutions for this?, i really appreciate whether it will do
another language or process in I series


Thanks

--
Regards,

William Salim
--
This is the RPG programming on the IBM i (AS/400 and iSeries) (RPG400-L)
mailing list To post a message email: RPG400-L@xxxxxxxxxxxx To

subscribe,

unsubscribe, or change list options,
visit: http://lists.midrange.com/mailman/listinfo/rpg400-l
or email: RPG400-L-request@xxxxxxxxxxxx
Before posting, please take a moment to review the archives at
http://archive.midrange.com/rpg400-l.

--
This is the RPG programming on the IBM i (AS/400 and iSeries) (RPG400-L)
mailing list
To post a message email: RPG400-L@xxxxxxxxxxxx
To subscribe, unsubscribe, or change list options,
visit: http://lists.midrange.com/mailman/listinfo/rpg400-l
or email: RPG400-L-request@xxxxxxxxxxxx
Before posting, please take a moment to review the archives
at http://archive.midrange.com/rpg400-l.

--
Regards,
Henrik Rützou

http://powerEXT.com <http://powerext.com/>
--
This is the RPG programming on the IBM i (AS/400 and iSeries) (RPG400-L)
mailing list
To post a message email: RPG400-L@xxxxxxxxxxxx
To subscribe, unsubscribe, or change list options,
visit: http://lists.midrange.com/mailman/listinfo/rpg400-l
or email: RPG400-L-request@xxxxxxxxxxxx
Before posting, please take a moment to review the archives
at http://archive.midrange.com/rpg400-l.