Submitting forms on the support site are temporary unavailable for schedule maintenance. If you need immediate assistance please contact technical support. We apologize for the inconvenience.
I Reverse Engineered a DB2 LUW 9.7 database. I notice that while in the Logical model, under Doma
Description
I Reverse Engineered a DB2 LUW 9.7 database. I notice that while in the Logical model, under Domains it is not showing any of the columns from any of my tables. Why?
Resolution
I Reverse Engineered a DB2 LUW 9.7 database. I notice that while in the Logical model, under... - CA Technologies ERwin Knowledge Base
Article ID: 322
Last updated: 24 Oct, 2012
Components:ERwin Data Modeler: 8.1
Last Modified Date: 02/17/2012
Document ID: TEC564580
Tech Document
Title: I Reverse Engineered a DB2 LUW 9.7 database. I notice that while in the Logical model, under Domains it is not showing any of the columns from any of my tables. Why?
Domain is a logical concept, it does not exist in the actual database for DB2, only in the case that the domain was defined in the database as a distinct type.
If distinct type was checked on during a Forward Engineer to the database, then ERwin will later be able to Reverse Engineer the column as a domain.
In the screen shot below (bottom right), distinct type is checked on in the model. Therefore, if the column is Forward Engineered to the database, then ERwin would later be able to Reverse Engineer that column under the domain.
Your Request will be reviewed by our technical reviewer team and, if approved, will be added as a Topic in our Knowledgebase.
Welcome to Quest Support
You can find online support help for Quest *product* on an affiliate support site. Click continue to be directed to the correct support content and assistance for *product*.
Search All Articles
IE 8, 9, & 10 No longer supported
The Quest Software Portal no longer supports IE8, 9, & 10 and it is recommended to upgrade your browser to the latest version of Internet Explorer or Chrome.