The DB2/390 glossary query returns the names of the database and tablespace which contain the table, the entity and data model which define the table and other characteristics of the DB2/390 table identified in the WHERE clause.
View type: DAQDB2390Table
Modifications:
Change the search criteria of the table name using the = (equals), IN or LIKE elements in the WHERE clause. In order to provide unique DB2/390 table names, the name has the format <>RelSystem:CreatorID:::TableName<variation:revision>.
To find all DB2/390 tables which have a specific simple name, use the LIKE clause with % as either or both of the first two qualifiers. To speed up your query, use % to include the colons and separators. For example, if you want all tables starting "CUST", specify LIKE '%::CUST%'.
#MODIFIED#
#VERSION#
#SQL STATEMENT#
SELECT DISTINCT
dt.db2390Table,
dt.creatorID,
dt.inRelationalSystem..relationalSystem,
dt.inPhysicalDesign..db2390PhysicalDesign,
dt.inTablespace..db2390Tablespace,
dt.inDatabase..db2390Database,
t.tableDefinition,
-- entity and data model which are the source of the table