Previous Topic: Define a DB2 LUW ModuleNext Topic: Support for Security Features in DB2 LUW


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.