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 begin

This topic assumes that you have created ESQL code for a file. For more information, see Creating ESQL for a node.

About this task

To modify ESQL code, complete the following steps.

Procedure

  1. 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.

  2. 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.
  3. 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 Referencing resources in other libraries.
  4. 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.
  5. When you have finished working with this module, save and close the ESQL file.

Results

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 Source > Format. 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).

Adding comments to ESQL

About this task

You can add and remove comments in your ESQL code.

Procedure

  • To change an existing line of code into a comment line, click Source > Comment.
  • To change a comment line to a code line, click Source > Uncomment.
  • To create a new comment line, press Enter to create a new line, then either type the comment identifier -- or click Source > Comment. You can enter any text after the identifier; everything that you type is ignored by the ESQL editor.