Hints and tricks for Ibm (DB2 ZOs, EGL)

SELECT * FROM
(SELECT t.CREATOR A, t.TYPE T, t.NAME N
FROM SYSIBM.SYSTABLES t
WHERE t.type in ('T','V')
union all
SELECT t.schema, t.SEQTYPE, t.NAME
FROM SYSIBM.SYSSEQUENCES t
WHERE t.SEQTYPE in ('S')
union all
SELECT t.OWNER, 'PCK', t.NAME
FROM sysibm.syspackage t
union all
SELECT distinct t.SCHEMA, t.ROUTINETYPE, t.NAME
FROM SYSIBM.SYSPARMS t
WHERE t.ROUTINETYPE in ('P','F')
) dd
order by 1, 2, 3
;