Description:
Using erwin Data Modeler 2020 R2, we need an ODBC query that reports on Subject Areas and the Tables in the Diagrams.
Solution:
Please run this query from the Query Tool to get the expected results.
SELECT
SA.NAME AS Subject_Area,
DGM.Name AS Diagram_Name,
Tran(E.Physical_NAME) AS Table_NAME
FROM
SA.NAME AS Subject_Area,
DGM.Name AS Diagram_Name,
Tran(E.Physical_NAME) AS Table_NAME
FROM
ER_MODEL_SHAPE S,
OBJECT_TYPE O,
ENTITY E ,
ER_DIAGRAM DGM ,
SUBJECT_AREA SA
WHERE
OBJECT_TYPE O,
ENTITY E ,
ER_DIAGRAM DGM ,
SUBJECT_AREA SA
WHERE
S.MODEL_OBJECT_REF = E.ID@
AND E.TYPE@= O.ID@
AND S.OWNER@ = DGM.ID@
AND DGM.OWNER@ = SA.ID@
ORDER By 1,2
AND E.TYPE@= O.ID@
AND S.OWNER@ = DGM.ID@
AND DGM.OWNER@ = SA.ID@
ORDER By 1,2

Comments
0 comments
Please sign in to leave a comment.