The RelationalCreatorContents relationship query returns the names of all DB2/390 tables, views, aliases, and indexes, all DB2 UDB tables, views and indexes, and all Oracle tables, views and indexes which have in the specified creator ID or schema name.
View type: DAQRelationalSystem
Modifications:
Change the search criteria of the creatorID using the = (equals), IN or LIKE elements in the WHERE clause . In order to provide unique CreatorID names, the creatorID name has the format <>RelationalSystem::::Creator ID<variation:revision>. To find all Creator IDs which have a specific name, use the LIKE clause with % before the first of four colons.
#MODIFIED#
#VERSION#
#SQL STATEMENT#
--DA_RelationalCreatorContents
SELECT DISTINCT
r.creatorID,
r.relationalSystem,
r.db2csTable..db2csTable as relatedObject,
'DB2 UDB Table' as partType,
p.lastUpdate,
p.addDate
FROM OUTER
DAQRelationalSystem r,
PartView p
WHERE
r.creatorID like '<>%::::%' AND
r.db2csTable..db2csTable=p.baseName AND
p.partType='DSRORDTable'
UNION
SELECT DISTINCT
r.creatorID,
r.relationalSystem,
r.db2csView..db2csView as relatedObject,
'DB2 UDB View' as partType,
p.lastUpdate,
p.addDate
FROM OUTER
DAQRelationalSystem r,
PartView p
WHERE
r.creatorID like '<>%::::%' AND
r.db2csView..db2csView=p.baseName AND
p.partType='DSRORDView'
UNION
SELECT DISTINCT
r.creatorID,
r.relationalSystem,
r.db2csIndex..db2csIndex as relatedObject,
'DB2 UDB Index' as partType,
p.lastUpdate,
p.addDate
FROM OUTER
DAQRelationalSystem r,
PartView p
WHERE
r.creatorID like '<>%::::%' AND
r.db2csIndex..db2csIndex=p.baseName AND
p.partType='DSRORDIndex'
UNION
SELECT DISTINCT
r.creatorID,
r.relationalSystem,
r.db2390Table..db2390Table as relatedObject,
'DB2/390 Table' as partType,
p.lastUpdate,
p.addDate
FROM OUTER
DAQRelationalSystem r,
PartView p
WHERE
r.creatorID like '<>%::::%' AND
r.db2390Table..db2390Table=p.baseName AND
p.partType='DSRMRDTable'
UNION
SELECT DISTINCT
r.creatorID,
r.relationalSystem,
r.db2390View..db2390View as relatedObject,
'DB2/390 View' as partType,
p.lastUpdate,
p.addDate
FROM OUTER
DAQRelationalSystem r,
PartView p
WHERE
r.creatorID like '<>%::::%' AND
r.db2390View..db2390View=p.baseName AND
p.partType='DSRMRDView'
UNION
SELECT DISTINCT
r.creatorID,
r.relationalSystem,
r.db2390Index..db2390Index as relatedObject,
'DB2/390 Index' as partType,
p.lastUpdate,
p.addDate
FROM OUTER
DAQRelationalSystem r,
PartView p
WHERE
r.creatorID like '<>%::::%' AND
r.db2390Index..db2390Index=p.baseName AND
p.partType='DSRMRDIndex'
UNION
SELECT DISTINCT
r.creatorID,
r.relationalSystem,
r.db2390AliasSynonym..db2390AliasOrSynonym as relatedObject,
'DB2/390 Alias/Synonym' as partType,
p.lastUpdate,
p.addDate
FROM OUTER
DAQRelationalSystem r,
PartView p
WHERE
r.creatorID like '<>%::::%' AND
r.db2390AliasSynonym..db2390AliasOrSynonym=p.baseName AND