Creating Models › Target Servers for Physical Models › Database Property Editors › DB2 z/OS Property Editors › Define DB2 for z/OS View Column Properties

Define DB2 for z/OS View Column Properties

In a model based on the DB2 for z/OS target server, you use the General tab in the View Column Editor to manage the domain parent, physical data type, and other properties for the selected column.

To define DB2 for z/OS view column properties

1. Right-click a view column in the Model Explorer and click Properties.

   The DB2 for z/OS View Column Editor opens.

2. Select the view from the View drop-down that contains the column that you want to define.
3. Select the column in the Navigation Grid that you want to define.

   Note: Click New on the toolbar to create a column. Use the Enter filter text text box to filter a large list of columns to locate the one that you want to define.

4. Click the General tab and work with the following options:

   Domain Parent

   Displays the current parent domain. You can change the domain using the check boxes. Use the toolbar to sort the domain list or open the Domain Editor to work with domains.

   Name

   Displays the view column name. You can change the name in this field or specify one of the following naming options:

   Inherit

   Specifies to inherit the view column name from the domain.

   Override

   Specifies to override inheritance of the view column name.

   Harden

   Specifies to harden the view column name.

   Physical Data Type

   Lets you select a data type from the drop-down list to apply to the selected column. If the selected data type requires a value for precision, scale, or both, enter the value inside the data type parentheses. For example, you can select the DECIMAL() data type and specify a precision of 2 and a scale of 10 inside the parentheses to assign the data type DECIMAL(2,10) to the selected column.

   Label

   Lets you specify the label that is added to the view column description in the server catalog.

5. (Optional) Click the Comment tab and enter any comments that you want to associate with the object.
6. (Optional) Click the Where Used tab to view where the object is used within the model.
7. (Optional) Click the UDP tab to work with user-defined properties for the object.
8. (Optional) Click the History tab to view the history information for the object.
9. (Optional) Click the Notes tab to view and edit user notes.
10. Click Close.

    View column properties are defined and the DB2 for z/OS View Column Editor closes.