×
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.
I read the thread. Apparently there seems to be an issue if the object
date on a file is updated if it has multiple members. Perhaps just one of
the members is updated.
But what I'm concentrating on is: Why is anyone still doing DSPOBJD to an
output file and querying that? Why aren't they using the system catalogs?
http://ibm.biz/DB2foriServices
https://www.ibm.com/support/knowledgecenter/ssw_ibm_i_73/db2/rbafzcatalog.htm
https://www.ibm.com/support/knowledgecenter/ssw_ibm_i_73/rzajq/rzajqservicesdb2.htm
https://www.ibm.com/support/knowledgecenter/ssw_ibm_i_73/rzajq/rzajqservicessys.htm
Object:
SELECT max(change_timestamp)
FROM TABLE(QSYS2.OBJECT_STATISTICS('ERPLXF', '*ALL')) AS a;
Member (aka partition):
SELECT max(last_change_timestamp)
from qsys2.syspartitionstat
where table_schema='ERPLXF';
Rob Berendt
This mailing list archive is Copyright 1997-2024 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].
Operating expenses for this site are earned using the Amazon Associate program and Google Adsense.
midrange.com
