Relationships and Domains › Domains and Data Modeling › Domains in the Physical Model › User Data Type Support Using Domains › Summary of User Data Type Schema Generation Options › DB2 LUW Distinct Types

DB2 LUW Distinct Types

When you assign the DB2 LUW target server to a model, the General tab in the Domain Editor contains a Distinct Type check box so you can generate a domain as a DB2 LUW distinct type. Select this check box to generate the selected domain as a DB2 LUW distinct type. Clear the check box if you want the selected domain to set column properties without being generated as a DB2 LUW distinct type.

In the Forward Engineer Schema Generation dialog you can determine how distinct types are generated in DB2 LUW. Each option in the Forward Engineer Schema Generation dialog that supports DB2 LUW Distinct Types is explained below:

Distinct Type

Specifies to include a CREATE DISTINCT TYPE statement for each user data type that you define in the Domain Editor.

Use Distinct Type

Specifies to include the USE DISTINCT TYPE clause in the CREATE TABLE statement for columns that are based on distinct types.

More information:

Define Schema Generation Schema Options

Define Schema Generation Column Options