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

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 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.