IBM Integration Bus, Version 10.0.0.9 Operating Systems: AIX, HP-Itanium, Linux, Solaris, Windows, z/OS


Custom ESQL

You use the Custom ESQL transform to call your own ESQL code from a graphical data map.

In the Graphical Data Mapping editor, select Custom ESQL from the Custom Transforms list. You can then use the transform properties to select ESQL code that is stored in your workspace. When you select the ESQL route, the Parameters table Name and Type columns are populated. You must then select an input element or XPath expression in the Value column for each parameter. You can use the content assist in the Value column to help you to assign the required element, literal, or XPath expression.

The following topics contain further information about ESQL types and functions:

The ESQL file that contains the referenced ESQL module must be visible for mapping to be selectable. Ensure that the application, library, or project references are set to make the ESQL file accessible to the map. When you deploy the map, ensure that the ESQL file is also deployed, and that Compile and in-line resources is not selected.

Requirements for ESQL modules that are called from a graphical data map

The following requirements apply to ESQL modules that are called from a graphical data map:

Note: The target element of a Custom ESQL transform is always created and given the value that is returned by the associated ESQL procedure. If the ESQL procedure returns ESQL NULL, the transform creates an element with an empty value. If you do not want an element to be created, you can add a conditional expression.

br28672_.htm | Last updated 2017-07-17 12:46:49