Developing ESQL

Customize processing implemented by the Compute, Database, DatabaseInput, and Filter nodes in your message flows by coding ESQL.

About this task

You must create, for each node, an ESQL module in which you code the ESQL statements and functions to tailor the behavior of the node. You can access message content, or database content, or both, to achieve the results that you require. ESQL modules are maintained in ESQL files, managed through the Integration Development perspective.

This section provides the following information:

ESQL overview
Managing ESQL files
Writing ESQL

You can use the ESQL debugger, which is part of the flow debugger, to debug the code that you write. The debugger steps through ESQL code statement by statement, so that you can view and check the results of every line of code that is run.