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)
When returning a License Code for erwin DM 2018 R1 , I received the error message, "You have exceeded the license's number of returns allowed. Please contact erwin Inc. Technical Support for further information."
Supertype-Subtype Relationship between two Parent supertype Entities pointing to the same the subtype Entity
What is the purpose of 'Use Data Type in Unification' ? How does it work?
Check the Maintenance End Date before upgrading from erwin DM 9.8 to erwin DM 2018 R1. You must have active maintenance to launch erwin 2018 R1.
I just installed or upgraded to erwin Data Modeler 2018 R1 and now Import and export to external format is disabled
Deleting Entities in bulk displayed in Model Explorer, but not in a Diagram.
Is it possible to save a .erwin file as a jpeg file?
How to display a Relationship appearing behind the Entity when inside a Shape or Annotation?

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