User-defined ESQL routines can be called from a mapping and the Compose Expression editors have specific support for this described in Applying ESQL function definitions. Every mapping file contains a single mapping procedure. This procedure is defined at schema scope (that is, outside a module scope), and can be reused from several nodes.
These mapping procedures can also be called from ESQL. The parameters to the procedure have the type ESQL REFERENCE. The REFERENCE has the logical structure specified by an XML Schema type xsd:complexType.
Database table names are hard-coded in the mapping. Database schema names cannot be specified and the broker default schema is always used. By mixing ESQL and mappings, you can create powerful bottom-up, top-down, and meet-in-the-middle transformations. For example, a single mapping can be iteratively applied for an unknown number of element instances by calling the mapping in an ESQL loop that counts from 1 to the element CARDINALITY.
Reusable ESQL functions are shown in the Compose Expression editor and in the ESQL content assist.
Related tasks
Applying ESQL function definitions
Defining the schema name
Related reference
Mappings
ESQL editor
Notices |
Trademarks |
Downloads |
Library |
Support |
Feedback
![]() ![]() |
ar03120_ |