Creating Models › Target Servers for Physical Models › Database Property Editors › DB2 LUW Property Editors › Define a DB2 LUW Module › Define a DB2 LUW Module Object Definition

Define a DB2 LUW Module Object Definition

You open the DB2 for LUW Module Object Definition Editor from a tab in the module editor.

To define a DB2 LUW module object definition

1. Click the Module Object Definition Editor icon in the Module Editor and work with the following properties:

   Name

   Specifies the module object definition name.

   Note: This name appears in the Forward Engineering script only when you select the Type as Condition. For other types, an ERwin-generated name appears in the Forward Engineering script.

   Action Type

   Specifies the action type for the module object definition. The action type can be Add or Publish.

   Type

   Specifies the module object definition type. Select a type from the drop-down list. Valid values are Condition, Function, Procedure, Type, or Variable.

2. Work with the following properties on the General tab:

   SQL State Value

   Specifies the SQL State that is associated with the condition. This field appears only when the Type field has a value of Condition.

   Function

   Specifies the function that is associated with the module. This field appears only when the Type field has a value of Function.

   Stored Procedure

   Specifies the store procedure that is associated with the module. This field appears only when the Type field has a value of Procedure.

   Domain

   Specifies the domain that is associated with the module. This field appears only when the Type field has a value of Type.

   Global Variable

   Specifies the global variable that is associated with the module. This field appears only when the Type field has a value of Variable.

3. Click Close.

   The DB2 for LUW Module Object Definition Editor closes.