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
설명
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?
해결 방안
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.
