I just built a DDS cross library logical and the following didn't
SELECT SYSTEM_INDEX_NAME, SYSTEM_INDEX_SCHEMA
, SYSTEM_TABLE_NAME, SYSTEM_TABLE_SCHEMA
ORDER BY system_index_schema, system_index_name
And it wasn't found in SYSVIEWS either.
This may help:
DSPFD FILE(ROB/IICL01) TYPE(*MBR) OUTPUT(*OUTFILE) FILEATR(*LF)
SELECT MBLIB, MBFILE, MBBOL, MBBOF, MBBOM
Library File Library Physical Member
ROB IICL01 ERPLXF IIC IIC
Might need some tweaking for Join LF's...
This mailing list archive is Copyright 1997-2014 by MIDRANGE dot 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 here. If you have questions about this, please contact