I found a possible replacement for QADBXREF: QSYS2.SYSTABLES (I know,
Does anyone see a problem with that?
In the interim, I've re-written the join (formerly on QADBXREF) as:
JOIN ( SELECT
Table_Schema AS LibName
, Table_Name AS FileName
, Table_Owner AS Owner
, Table_Text AS Desc
WHERE Table_Type IN ( 'P', 'T' )
AND File_Type = 'D'
ORDER BY Table_Schema, Table_Name
ON A.Table_Schema = T.LibName
AND A.Table_Name = T.FileName
Now, I need the Creation Date from somewhere other than the DSPOBJD outfile.
"Contrariwise, if it was so, it might be; and if it were so, it would
be; but as it isn't, it ain't. That's logic."--Tweedledee