CREATE MODULE statement

The CREATE MODULE statement creates a module, which is a named container associated with a node.

Syntax

Notes:
  1. IDENTIFIER must be a valid function name
  2. ModuleStatement is a DECLARE, CREATE PROCEDURE or CREATE FUNCTION statement.

A module in the Eclipse tools is referred to from a message processing node by name. The module must be in the <node schema>.

Module names occupy the same symbol space as functions and procedures defined in the schema. That is, modules, functions, and procedures contained by a schema must all have unique names.
Note: You are warned if there is no module associated with an ESQL node. You cannot deploy a flow containing a node in which a module is missing.

The modules for the Compute node, Database node, and Filter node all contain a function that returns a boolean. The special module routine is named Main and it is the entry point for a message flow node to process the ESQL routines defined within a module for the node. At most, one Main function is allowed in a module.

Correlation name Compute module Filter module Database module
Database × × ×
Environment × × ×
Root   × ×
Body   × ×
Properties   × ×
DestinationList   × ×
ExceptionList   × ×
LocalEnvironment   × ×
InputRoot ×    
InputBody ×    
InputProperties ×    
InputDestinationList ×    
InputExceptionList ×    
InputLocalEnvironment ×    
OutputRoot ×    
OutputDestinationList ×    
OutputExceptionList ×    
OutputLocalEnvironment ×    
Related concepts
ESQL
Related tasks
Developing ESQL
Related reference
Syntax preference
ESQL statements
BROKER SCHEMA statement
PATH clause