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.
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.