Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

...

Code Block
languagesql
SELECT DETALSDETAILS.* FROM TABLE(QHASM.ADMIN_DOMAIN_MRE_LIST(GLOBAL_STATUS => '*INCONSISTENT')) LIST,
                     TABLE(QHASM.ADMIN_DOMAIN_MRE_DETAILS(MONITORED_RESOURCE => LIST.MONITORED_RESOURCE, RESOURCE_TYPE => LIST.RESOURCE_TYPE, LIBRARY => LIST.LIBRARY)) DETAILS
                WHERE DETAILS.LOCAL_STATUS != 'CURRENT';

...