On 26-Feb-2014 07:51 -0800, rob@xxxxxxxxx wrote:
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.
A DDS LF is neither a VIEW nor an INDEX. The SYSINDEXES omits all
but DBXATR='IX' and the SYSVIEWS omits all but DBXATR='VW'. Thus a
similar query [optionally encapsulated in a VIEW] that includes all LFs
[and MQTs] should suffice to effect a similar inquiry about
cross-library dependencies from the System Database Cross-Reference Files.
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...
As I recall, the Join logical files should have the same information
whereby there may be multiple rows for any one logical file member; i.e.
one row for each referenced\based-on file member.