I Reverse Engineered a DB2 LUW 9.7 database. I notice that while in the Logical model, under Doma (4294117)

Return

Feedback Submitted

Did this article solve an issue for you?

Select Rating

Title

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.

Figure 1.

Feedback Submitted

Did this article solve an issue for you?

Select Rating

Request a KB Article

Please select your product:

To serve you better, please complete the Purpose of your Chat:

Recommended Solutions for Your Problem

I Reverse Engineered a DB2 LUW 9.7 database. I notice that while in the Logical model, under Doma (4294117)

Title

Description

Resolution

Article ID: 322

Tech Document

Leave a Comment