The Custom ESQL transform enables you 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 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 ESQL file that contains the referenced ESQL module must be visible for mapping to be selectable. Ensure the application, library, or project references are set to make the ESQL file accessible to the map. When deploying the map, ensure the ESQL file is also deployed, and that Compile and in-line resources is not selected.
The following requirements apply to ESQL modules that are called from a graphical data map: