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

Yes, I probably should have mentioned this caveat, and I don't think the reason for the change is part of the data returned.


One question we haven't asked is what kind of change Suren needs to know about. Is it compiled objects? One might need to burrow down to source change date & time. I don't know if the audit journal entries are more granular as to why the change occurred.


And what do the SAV* commands use to determine something has changed, when we specify to include changed objects in the save?

Cheers
Vern


On Thu, 11 Jul, 2024 at 8:40 PM, smith5646midrange@xxxxxxxxx <smith5646midrange@xxxxxxxxx> wrote:


To: 'rpg programming on ibm i'

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<mailto: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<mailto:rpg400-l@xxxxxxxxxxxxxxxxxx>
Cc: VERNON HAMBERG Owner <vhamberg@xxxxxxxxxxxxxxx<mailto:vhamberg@xxxxxxxxxxxxxxx>>;
rpg400-l@xxxxxxxxxxxxxxxxxx<mailto: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<mailto: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><mailto: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@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><mailto: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<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@xxxxxxxxxxxxxxxxxx>
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.