RE: Reg: Objects Added/Modified/Deleted Timestamp in IBMi

We found that looking at object change date caused a lot of false hits
because there are number of things that alter that date including changing
the authority on the object. We ended up using the create date and the
restore date. However, be aware that UPDPGM and UPDSRVPGM will not be
caught using these dates.



-----Original Message-----
From: RPG400-L <rpg400-l-bounces@xxxxxxxxxxxxxxxxxx> On Behalf Of VERNON
HAMBERG Owner via RPG400-L
Sent: Thursday, July 11, 2024 12:51 PM
To: rpg400-l@xxxxxxxxxxxxxxxxxx
Cc: VERNON HAMBERG Owner <vhamberg@xxxxxxxxxxxxxxx>;
rpg400-l@xxxxxxxxxxxxxxxxxx
Subject: Re: Reg: Objects Added/Modified/Deleted Timestamp in IBMi

Hi Suren


Since it is only 1 library, I suggest using the OBJECT_STATISTICS table
function -


https://www.ibm.com/docs/en/i/7.5?topic=services-object-statistics-table-fun
ction


It gives you the timestamp when created and the timestamp when changed I
would use something in the WHERE clause about one of those timestamps being
greater than when you last checked.


HTH
Vern


On Thu, 11 Jul, 2024 at 9:00 AM, Suren K <suren7437@xxxxxxxxx> wrote:


To: rpg programming on ibm i

Hi All,

I have a requirement under a specific library, we need to identify whether
an existing object got modified or a new object got added to the library.

Other than Journal, do we have any IBMi-provided system file object that
will contain these details?

Regards,
Suren
--
This is the RPG programming on IBM i (RPG400-L) mailing list To post a
message email:
RPG400-L@xxxxxxxxxxxxxxxxxx<mailto:RPG400-L@xxxxxxxxxxxxxxxxxx>
To subscribe, unsubscribe, or change list options,
visit: https://lists.midrange.com/mailman/listinfo/rpg400-l
or email:
RPG400-L-request@xxxxxxxxxxxxxxxxxx<mailto:RPG400-L-request@lists.midrange.c
om>
Before posting, please take a moment to review the archives at
https://archive.midrange.com/rpg400-l.

Please contact
support@xxxxxxxxxxxxxxxxxxxx<mailto:support@xxxxxxxxxxxxxxxxxxxx> for any
subscription related questions.

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

Please contact support@xxxxxxxxxxxxxxxxxxxx for any subscription related
questions.