Re: DSPFD *USRLIBL Broken?

[Rob Berendt <rob@xxxxxxxxx>]

Sort of like the information one could glean from these statements in Run 
SQL Scripts?
CL:  addlible ERPLXS;
CL: ADDLIBLE ERPLXUSRS;

Select SYSTEM_TABLE_SCHEMA, SYSTEM_TABLE_NAME, SYSTEM_TABLE_MEMBER,
        SOURCE_TYPE, PARTITION_TEXT,
        LAST_CHANGE_TIMESTAMP, LAST_SAVE_TIMESTAMP, LAST_USED_TIMESTAMP
FROM QSYS2.SYSPARTITIONSTAT
WHERE SOURCE_TYPE IS NOT NULL
AND SYSTEM_TABLE_SCHEMA IN(
        SELECT SCHEMA_NAME
        FROM QSYS2.LIBRARY_LIST_INFO
        WHERE TYPE = 'USER')
;


Rob Berendt