The DB2 UDB foreign keys impact analysis query returns the names of DB2 UDB tables with foreign keys which are constrained by the DB2 UDB table identified in the SQL WHERE clause.
View type: DAQDB2csTable
Modifications:
Change the search criteria of the DB2 UDB table using the = (equals), IN or LIKE elements in the SQL WHERE clause.
#MODIFIED#
#VERSION#
#SQL STATEMENT#
--DA_DB2udbTableForeignKeys
SELECT
t.db2csTable,
td.tableDefinition,
kd.primaryKeyDependentDB2csTable as dependentTable