WebSphere Message Brokers
File: ar25139_
Writer: Cerys Giddings

Task topic

This build: July 31, 2007 21:36:09

Calling a submap from ESQL

You can use the Message Mapping editor to perform mappings to a certain level of complexity. To create even more complex mappings, use ESQL. ESQL is particularly suitable for interacting with databases.

If a submap does not already exist, create one.

The following steps describe how to call a submap from ESQL. Calling a submap from ESQL uses different parameters to when you call a submap from another map due to this extra level of complexity (when calling a submap from ESQL, the two local environment parameters are added at the end of the CALL statement).

  1. Switch to the Broker Application Development perspective.
  2. Right-click a node that supports ESQL and click Open ESQL. The ESQL file opens for that node.
  3. Add a CALL statement to call a submap. Alternatively, press Ctrl+Space to access ESQL content assist, which provides a drop-down list that includes the submap name and expected parameters.

    The following syntax diagram demonstrates the CALL statement:

Notes:
  1. Only source parameters appear in the call and only message parameters appear in the list.
  2. If the submap builds a message target, include the target path and OutputLocalEnvironment parameters. If the submap does not build a message target (for example, if the submap interacts with a database), these two parameters do not appear.
Related tasks
Calling a submap
Creating a new submap
Creating a new submap for a wildcard source
Creating and calling submaps and subroutines
Notices | Trademarks | Downloads | Library | Support | Feedback

Copyright IBM Corporation 1999, 2007Copyright IBM Corporation 1999, 2007. All Rights Reserved.
This build: July 31, 2007 21:36:09

ar25139_ This topic's URL is: