A license for erwin DM could not be obtained. The application will shut down. Error codes: 7(-96,491,0)
Cannot launch application after upgrade from 9.x to 9.7 - Error Codes: 7 (-1,359,2)
In Earlier Version of Erwin like 7.X, we were able to create table space name like &TEST_DATA. Now in 9.x not able to create table space name &TEST_DATA. If I am trying to create also it makes _TEST_DATA automatically.
Report Designer: how to get Attribute Order (and Column Order) to display in the grid, and then be exported to a file?
I don't see "Forward Engineer" available in Actions menu
Query to generate Relationship Names, Parent and Child Table Names and PK and FK Column Names
Why Attribute order in Model Explorer is different than in Attribute Editor? How to match them?
What is the process to reactivate popup screen after it is disabled?
When trying to open any .erwin file by double clicking it, the erwin installation starts. Do you know why?
How can I change the default prefix that erwin assigns to the Primary Keys? By default it appears XPK and I need to change it to PK?

See more

CA ERwin DM: query to return Table name, UDP name, and UDP values

Updated April 19, 2018 08:12

Article ID: 2873

Last updated: 22 Aug, 2012

Title: CA ERwin DM: query to return Table name, UDP name, and UDP values.

Description:

Query to return Table name, UDP name, and UDP values.

Solution:

select    O.Name as "Table Name",
              PT.Name as "UDP name",
              tag_UDP_values_list as"UDP values"
from      Entity O, Property_type PT
where    PT.tag_is_locally_defined = 'T'

Comments

1 comment

Alejandra Silva August 03, 2017 21:05

Which would be an option in ERwin r9? Specify in ERwin 9.601?

Thank you!

:)

-1

Permalink

Please sign in to leave a comment.

Powered by Zendesk