Online Documentation for SQL Manager for DB2

Editing module


This how Module Editor looks when an existing module is opened.

 

Module - Editing Module

 

 

Module name and Module schema fields contain module name and its parent schema correspondingly and can't be modified.

 

The Edit tab of the wizard consists of five tabs: Conditions, Variables, Procedures, Functions, Types.

 

Select a tab to manage corresponding module object.

 

Context menu allows you to iconPlus Add, iconPublish Publish or iconMinus Delete an object.

 

Use the iconPlus Add item to add an object to the module.

Use the iconPublish Publish item to add a new object to the module and make it available for use outside the module.

Use the iconMinus Delete item to remove selected object from the module.

 

When you add or publish an object, the corresponding editor appears. Topics listed below provide you with necessary information about these editors:

 

Creating/editing SQL Variable

Creating/editing procedure

Creating/editing function

Creating/editing UD Type

 

Condition

You can define conditions, that can be used by module functions.

 

Module - Conditions

 

Condition name

Define the name of the condition. The name must not identify an existing condition in the module.

 

SQL state

Specify the SQLSTATE that is associated with the condition. The string-constant must be specified as five characters and must not be '00'.