Creating a module object for DB2 V9.7 for Linux, UNIX, and Windows

Create a module object that contains objects like functions, stored procedures, variables, and data types.

Before you begin

Create a DB2® V9.7 for Linux®, UNIX®, and Windows® connection.

Procedure

To create a module, from the Data Source Explorer:

  1. Expand the Schemas folder and right-click on a schema object.
  2. Select Create > Module. The Data Object Editor opens.
  3. Type a name and label, and click other tabs to add other objects, such as privileges, conditions, or variables. On each page, you can add, delete, or edit the object, and for some objects, you can publish them to make them available outside of the module.
  4. Click Run DDL create the module.

Results

A module object is created and displayed in the Data Source Explorer. Ensure that the objects in the module are syntactically correct before deploying the module.

Feedback