WebSphere Message Broker, Version 8.0.0.7
Operating Systems: AIX, HP-Itanium, Linux, Solaris, Windows, z/OS
See information about the latest product version
See information about the latest product version
Equivalent ESQL and XPath mapping functions
You can implement some data mapping functions either by using XPath functions or by supplying equivalent ESQL functions in a Custom ESQL transform.
The following functions in the ESQL language have equivalent XPath functions built into the Graphical Data Mapping editor. You can invoke these functions directly without having to write ESQL modules in an ESQL file to be called from the map:
ESQL function | XPath function |
---|---|
EXTRACT YEAR FROM | fn:year-from-date |
EXTRACT MONTH FROM | fn:month-from-date |
EXTRACT DAY FROM | fn:day-from-date |
EXTRACT HOUR FROM | fn:hours-from-dateTime |
EXTRACT MINUTE FROM | fn:minutes-from-dateTime |
EXTRACT SECOND FROM | fn:seconds-from-dateTime |
EXTRACT DAYS FROM | fn:days-from-duration |
EXTRACT MONTHS FROM | fn:months-from-duration |
CURRENT_DATE | fn:current-date |
CURRENT_TIME | fn:current-time |
CURRENT_TIMESTAMP | fn:current-dateTime |
LOCAL_TIMEZONE | fn:implicit-timezone |
ABS (ABSVAL) | fn:abs |
CEIL (CEILING) | fn:ceiling |
FLOOR | fn:floor |
LEFT | fn:substring |
CONTAINS | fn:contains |
ENDSWITH | fn:ends-with |
LENGTH | fn:string-length |
LOWER (LCASE) | fn:lower-case |
REPLACE | fn:replace |
RIGHT | fn:substring |
STARTSWITH | fn:starts-with |
SUBSTRING … FROM | fn:substring |
SUBSTRING … BEFORE | fn:substring-before |
SUBSTRING … AFTER | fn:substring-after |
SUBSTRING … FROM … FOR | fn:substring(fn:substring(…), $for) |
SUBSTRING … BEFORE … FOR | fn:substring(fn:substring-before(…), $for) |
SUBSTRING … AFTER ... FOR | fn:substring(fn:substring-after(…), $for) |
TRANSLATE | fn:translate |
UPPER (UCASE) | fn:upper-case |
FIELDNAME | fn:local-name |
FIELDNAMESPACE | fn:namespace-uri |
CARDINALITY | fn:count |
EXISTS | fn:exists |