The DataElementUsage impact analysis query returns the names of all the objects which directly use a Shareable Data Element and may be impacted by changes to its data specification.
View type: DAQDataElementUsage
Modifications:
The query uses a SQL UNION clause to provide a more compact result table. The result table contains five columns: the data element name, what kind of object the row represents, the object which uses the data element and, if necessary, objects which contain the related objects.
If you are not interested in a particular type of object, you should delete the subselect from the query.
In order to change the search criteria, you must change it for each subselect statement in the UNION. Change the search criteria of the dataElement using the = (equals), IN or LIKE elements in the SQL WHERE clause.
#MODIFIED#
#VERSION#
#SQL STATEMENT#
-- Data element used by columns in relational tables
SELECT DISTINCT
d.dataElement as dataElement,
'Relational Column' as relatedType,
d.ColumnName as relatedObject,
t.tableDefinition as container1,
'' as container2
FROM OUTER
DAQDataElementUsage d,
(d.inTableDefinition) t,
PartView p
WHERE
d.dataElement like '<>%' AND
(t.tableDefinition = p.baseName AND
p.partType='DSRTableDefinition')
UNION
-- Data element used by IMS fields which are not shared
-- with a data structure
SELECT DISTINCT
d.dataElement as dataElement,
'IMS Field' as relatedType,
d.imsField as relatedObject,
d.imsSegment as container1,
db.rootDBDName as container2
FROM OUTER
DAQDataElementUsage d,
(d.inDBD) db,
PartView p
WHERE
d.dataElement like '<>%' AND
(db.rootDBDName = p.baseName AND
p.partType='DSDBD')
UNION
-- Data element used by IMS fields which are shared with
-- a data structure
SELECT DISTINCT
d.dataElement as dataElement,
'IMS Field' as relatedType,
d.imsFieldS as relatedObject,
d.imsSegmentS as container1,
db.rootDBDName as container2
FROM OUTER
DAQDataElementUsage d,
(d.inDBDs) db,
PartView p
WHERE
d.dataElement like '<>%' AND
(db.rootDBDName = p.baseName AND
p.partType='DSDBD')
UNION
-- Data element used by a data structure
SELECT DISTINCT
d.dataElement as dataElement,
'Shareable Data Structure' as relatedType,
s.dataStructure as relatedObject,
' ' as container1,
' ' as container2
FROM OUTER
DAQDataElementUsage d,
(d.inDataStructure) s,
PartView p
WHERE
d.dataElement like '<>%' AND
(s.dataStructure = p.baseName AND
p.partType='DSDataStructure')
UNION
-- Data element used directly by an included source definition
SELECT DISTINCT
d.dataElement as dataElement,
'Included Source' as relatedType,
i.includedSourceDefinition as relatedObject,
' ' as container1,
' ' as container2
FROM OUTER
DAQDataElementUsage d,
(d.inIncludedSource) i,
PartView p
WHERE
d.dataElement like '<>%' AND
(i.includedSourceDefinition = p.baseName AND
p.partType='DSIncludedSourceDef')
UNION
-- Data element used by a VisualAge Generator data item