Previous Topic: Define a DB2 LUW Index ExtensionNext Topic: Define a DB2 LUW Module Object Definition


Define a DB2 LUW Module

Use the DB2 for LUW Module Editor to work with module properties.

Note: This topic applies to DB2 for LUW version 9.7 only.

To define a DB2 LUW module

  1. Right-click a Module in the Model Explorer and select Properties.

    The DB2 for LUW Module Editor opens.

  2. Select a module and work with the following options:

    Note: Click New New icon in property editors to create a new object on the toolbar to create a module.

    Name

    Specifies the name of the module.

    Schema

    Specifies the default schema for the module. Select a schema from the drop-down list.

    Use Replace Syntax

    Specifies that Forward Engineering will use the CREATE OR REPLACE command instead of the CREATE command.

    Note: This field applies to DB2 for LUW version 9.7 only.

    Generate

    Specifies whether or not to generate DDL for this object during Forward Engineering.

  3. Work with the following options on the Module Object Definition tab:
    Name

    Specifies the name of the object associated with the module. To add a new module object, click the Module Object Definition Editor icon to open the Module Object Definition editor.

    Note: For Condition type object, the value you specify for the Name option is treated as the Condition Name.

    Action Type

    Specifies the action performed on the module object. Select from the drop-down list; valid values are Add and Publish.

    Type

    Specifies the type of the module object definition. Select from the drop-down list; valid values are Condition, Function, Procedure, Type and Variable.

  4. Click the Alias tab. Select the module name and click the new icon.

    A new alias is created for the module and displayed under the selected module name.

  5. Select a schema for the alias from the Schema drop-down list.

    You can create a child-alias for the selected alias by clicking the New icon.

    Note: The Alias tab for a Module applies to DB2 for LUW version 9.7 only.

  6. Click the Permission tab to specify permissions for the selected module.
  7. (Optional) Click the Comment tab and enter any comments that you want to associate with the object.
  8. (Optional) Click the UDP tab to work with user-defined properties for the object.
  9. (Optional) Click the Notes tab to view and edit user notes.
  10. Click Close.

    The DB2 for LUW Module Editor closes.