The Table Definition Usage impact analysis query returns the names of all DB2/390 and DB2 UDB and Oracle tables which directly use a Shareable Table Definition and may be impacted by changes to its specification. DB2/390 tables are of partType DSRMRDTable. DB2 UDB tables are of partType DSRORDTable. Oracle tables are of partType DSROracleTable.
View type: DAQTableDefinitionUsage
Modifications:
This query uses a SQL UNION clause to make a more compact and readable table. To change the search criteria you must change it in each of the subselect statments. Qualify the tableDefinition name using the = (equals), IN or LIKE elements in the SQL WHERE clause.