Relationships and Domains › Domains and Data Modeling › Domains in the Physical Model › User Data Type Support Using Domains › Add a User-Defined Data Type in a Physical Model

Add a User-Defined Data Type in a Physical Model

User-defined data types are only supported for DB2 LUW, SQL Server, and Sybase in a physical model.

Note: You cannot add user-defined data types to any of the standard domains (<default>, Blob, Datetime, Number, and String).

To add a user-defined data type

1. Click Domains on the Model menu.

   The Domain Editor opens.

2. Select the domain in the Navigation Grid to which you want to add a user-defined data type.

   Note: To filter a large list of domains, enter the name (or the first few characters) of the domain for which you want to add a user-defined data type in the Enter filter text box.

3. Click the General tab and select one of the following options depending on your target server:

   Distinct Type

   Creates a DB2 LUW Distinct Type.

   Generate As Udd

   Creates a SQL Server or Sybase User-defined data type.

4. Click Close.

   The user-defined data type is added to the domain in the physical model and the Domain Editor closes.

Note: If you clear the Generate As Udd check box, the data type of the domain appears in the diagram as the data type.

More information:

User Data Type Support Using Domains

Add a Domain in the Physical Edit Mode