The DB2390 foreign keys impact analysis query returns the names of DB2/390 Tables with foreign keys which are constrained by the DB2/390 Table identified in the SQL WHERE clause.
View type: DAQDB2390Table
Modifications:
Change the search criteria of the DB2/390 table using the = (equals), IN or LIKE elements in the SQL WHERE clause.
#MODIFIED#
#VERSION#
#SQL STATEMENT#
SELECT
t.db2390Table,
td.tableDefinition,
kd.primaryKeyDependentDB2390Table as dependentTable