×
The internal search function is temporarily non-functional. The current search engine is no longer viable and we are researching alternatives.
As a stop gap measure, we are using Google's custom search engine service.
If you know of an easy to use, open source, search engine ... please contact support@midrange.com.
Correct. I just want to know when the member is re-saved and unlocked so I can note it.
I have an exit point I'm using that gets close enough in RDI, but would be nice to know when is actually done with the change.
I'm using your other SQL sample for other purposes. Thanks for that one !!
Regards,
Richard Schoen
Web:
http://www.richardschoen.net
Email: richard@xxxxxxxxxxxxxxxxx
Phn: (612) 315-1745
-----Original Message-----
message: 5
date: Tue, 30 Jul 2019 20:07:50 +0000
from: Rob Berendt <rob@xxxxxxxxx>
subject: RE: Catching Source Member Changes
I'm going to assume you didn't mean the obvious ADDPFTRG on a source physical file.
You wanted to know a member was changed and not each row which was changed.
And any source PF from any method: RDi, SEU, EDTF, etc
And you wanted a trigger, not something like
SELECT system_table_member, system_table_schema, system_table_name,
source_type, last_source_update_timestamp
FROM QSYS2.SYSPARTITIONSTAT
where source_type is not null
fetch first 5 rows only
;
-- order by last_source_update_timestamp desc
Rob Berendt
As an Amazon Associate we earn from qualifying purchases.