The incomplete DB2/390 table query returns the names of DB2/390 Tables which are incomplete. During the DataAtlas populate function an incomplete table is created when an unknown table is referenced by a foreign key in the table being populated.
To complete the table defintion you must populate it.
View type: DAQDB2390Table
Modifications:
None.
#MODIFIED#
#VERSION#
#SQL STATEMENT#
SELECT
t.db2390Table,
kd.primaryKeyDependentDB2390Table as dependentTable
FROM OUTER
DAQDB2390Table t,
(t.usesTableDefinition) td,
(td.hasKeyDefinition) kd
WHERE
t.usesTableDefinition is null OR
EXISTS (SELECT 1
FROM (t.usesTableDefinition) tc
WHERE tc.columnName IS NULL or tc.columnName = '')