WebSphere Message Brokers
File: ac06000_
Writer: Bill Oppenheimer

Task topic

This build: July 31, 2007 21:17:47

Writing ESQL

This set of topics discusses ESQL and the ways in which you can use it to customize these nodes.

When you create a message flow, you include input nodes that receive the messages and, optionally, output nodes that send out new or updated messages. If required by the processing that must be performed on the message, you can include other nodes after the input node that complete the actions that your applications need.

Some of the built-in nodes allow you to customize the processing that they provide. The Compute, Database, and Filter nodes require you to provide a minimum level of ESQL, and you can provide much more than the minimum to control precisely the behavior of each node.

The DataDelete, DataInsert, DataUpdate, Extract, Mapping, and Warehouse nodes provide a mapping interface with which you can customize their function. The ways in which you can use the mapping functions associated with these nodes are described in developing message mappings, see the related links.

ESQL provides a rich and flexible syntax for statements and functions that let you check and manipulate message and database content. You can:

The following topics provide more information about these and other tasks that you can perform with ESQL. Unless otherwise stated, these guidelines apply to messages in all message domains except the BLOB domain, for which you can implement a limited set of actions.

The following topics provide additional information specific to the parser that you have specified for the input message:

ESQL examples

Most of the examples included in the topics listed above show parser-independent ESQL. If examples include reference to MRM, they assume that you have modeled the message in the MRM and that you have set the names of the MRM objects to be identical to the names of the corresponding tags or attributes in the XML source message. Some examples are also shown for the XML domain. Unless stated otherwise, the principals illustrated are the same for all message domains. For domain-specific information, refer to the appropriate link in the list above.

Most of the topics that include example ESQL use the ESQL sample message, Invoice, as the input message to the logic. This example message is provided in XML source format (with tags and attributes), see the related links for more information, and is shown below in diagrammatic form.

The topics specific to the MRM domain use the message that is created in the following sample: You can view samples only when you use the information center that is integrated with the Message Brokers Toolkit.

A few other input messages are used to show ESQL that provides function on messages with a structure or content that is not included in the Invoice or Video samples. Where this occurs, the input message is included in the topic that refers to it.

Example ESQL message Invoice presented in diagrammatic form
Notices | Trademarks | Downloads | Library | Support | Feedback

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

ac06000_ This topic's URL is: