Modifying ESQL for a node
To change the customization of
a node that requires ESQL (Compute, Database, DatabaseInput, or Filter node), modify the ESQL
statements in the module that you created for that node.
Before you start:This topic
assumes that you have created ESQL code for a file. For more information,
see Creating ESQL for a node.
To modify ESQL code, complete the
following steps.
- Open the message flow with which you want to work. In the Application
Development view, expand
the appropriate application, library, or integration project, expand the Flows folder,
then double-click the message flow.)
The message
flow is opened in the Message Flow editor.
- Right-click the node that corresponds to the ESQL module
that you want to modify and click Open ESQL. The ESQL file is opened in the editor view. The module
for this node is highlighted.
- Make the required changes in the module by entering new
statements, changing existing statements by over-typing, or deleting
statements by using the Delete or backspace keys. You can use Content
Assist, available from the Edit menu or, on
some systems, by pressing Ctrl+Space). To get Content Assist to work
with message references, you must set up a project reference from
the project containing the ESQL to the project containing the message
set. For information about setting up a project reference, see Adding and removing library references.
- You can change the name of the module with which you are
working by over-typing the current name with the new one. In this
case, you must also change the node property ESQL Module to reflect the new name,
to ensure that the correct ESQL code is deployed with the node.
- When you have finished working with this module, save and
close the ESQL file.
You can also open the ESQL file directly
by double-clicking it in the Application
Development view.
You can select the module with which you want to work from the Outline
view.
The editor provides functions that you can use to help
you modify your ESQL code. These functions are described in ESQL editor.
You can also
modify the ESQL source by clicking . This option formats all
selected lines of code (unless only partially selected, when they
are ignored), or, if no lines are selected, formats the entire file
(correcting alignments and indentation).