You can put DSPFD out to an outfile and query it.

DSPFD FILE(yourschema/*ALL)

There are fields for last changed century, date, and time - this is per member, but if all are single-member files, no problem.

With SQL you can test for the date being within the last day or any number of days before current date.


On 4/7/2011 11:02 AM, Dave Boettcher wrote:
On a somewhat regular basis, we need to determine whether or not the data in tables in a schema have been updated. There are about 100 tables in this schema and an update is run daily. Not all tables are necessarily updated each day. I have been just doing a DSPFD and scrolling down to the member list and looking at the last change date and time for the member.
This morning I thought there must be a way to find this using the SYS* tables created when you create a schema so that I could automate this checking process. I have looked at QADBXREF and QADBIFLD but have only found when the table itself was last changed, not when the data changed. So I ran DSPFD *MBRLIST to an out file and of course it's there as last change date. But isn't there a place on the system provided tables where it would be also?

All help is appreciated.



Dave B

Two rules to eliminate stress:
1. Don't sweat the small stuff. 2. It's all small stuff.

The information in this e-mail message (including any information contained in attachments hereto) is intended only for use of the addressee. This e-mail message may contain confidential or privileged information. If you receive this e-mail message unintentionally, please notify the sender immediately and then delete this message. E-mail transmission is not guaranteed to be secured or error free. The sender is not liable for any errors or omissions in the content of this e-mail message, which may arise as a result of e-mail transmission. E-mails, text messages, and other electronic communications made or received in connection with the transaction of public business, the expenditure of public funds, or the administration of public property are subject to the Wisconsin Public Records Law.

This thread ...


Follow On AppleNews
Return to Archive home page | Return to MIDRANGE.COM home page

This mailing list archive is Copyright 1997-2020 by midrange.com and David Gibbs as a compilation work. Use of the archive is restricted to research of a business or technical nature. Any other uses are prohibited. Full details are available on our policy page. If you have questions about this, please contact [javascript protected email address].