Use catalog view SYSCAT.TABDEP. (In the DB2 catalog, view information is generally found in the same catalog views as tables).
To just get tables that a view depends on you could use a query like
Code:
SELECT TD.BSCHEMA, TD.BNAME
FROM SYSCAT.TABDEP TD
WHERE TD.BTYPE='T'
AND TD.TABSCHEMA='<schema your view is in>'
AND TD.TABNAME='<your view name>'
Leave a comment: