|
|
|
Example: Query for returning the logical and physical names for all attributes, unified or not
SELECT TRAN(E.NAME) || '.' || TRAN(A.NAME) AS 'LOGICAL',
TRAN(E.PHYSICAL_NAME) || '.' || TRAN(A.PHYSICAL_NAME) AS 'PHYSICAL'
FROM M0.ENTITY E INNER JOIN M0.ATTRIBUTE A
ON E.ID@ = A.OWNER@
ORDER BY 1, 2
Example: Query for returning the logical and physical names for all attributes, filtering out unified attributes
SELECT TRAN(E.NAME) || '.' || TRAN(A.NAME) AS 'LOGICAL',
TRAN(E.PHYSICAL_NAME) || '.' || TRAN(A.PHYSICAL_NAME) AS 'PHYSICAL'
FROM M0.ENTITY E INNER JOIN EM0.MV_VISIBLE_ATTRIBUTE@ A
ON E.ID@ = A.OWNER@
ORDER BY 1, 2
| Copyright © 2011 CA. All rights reserved. | Tell Technical Publications how we can improve this information |