Equivalent ESQL types and schema types
When you need to process the data to set a target value, you can implement a function in Java™ or ESQL. If you choose to use ESQL functions, you can invoke them from your map in a custom ESQL transform.
The following table shows the equivalence between schema types and ESQL types:
| XML Schema simple type | ESQL data type in message tree |
|---|---|
| anyURI | CHARACTER |
| base64Binary | BLOB |
| boolean | BOOLEAN |
| byte | INTEGER |
| date | DATE |
| dateTime | TIMESTAMP |
| dayTimeDuration | INTERVAL |
| decimal | DECIMAL |
| double | FLOAT |
| duration | INTERVAL |
| ENTITIES | Repeating set of elements in the tree, each of type CHARACTER |
| ENTITY | CHARACTER |
| float | FLOAT |
| gDay | DATE |
| gMonth | DATE |
| gMonthDay | DATE |
| gYear | DATE |
| gYearMonth | DATE |
| hexBinary | BLOB |
| ID | CHARACTER |
| IDREF | CHARACTER |
| IDREFS | Repeating set of elements in the tree, each of type CHARACTER |
| int | INTEGER |
| integer | DECIMAL |
| language | CHARACTER |
| long | INTEGER |
| Name | CHARACTER |
| NCName | CHARACTER |
| negativeInteger | DECIMAL |
| NMTOKEN | CHARACTER |
| NMTOKENS | Repeating set of elements in the tree, each of type CHARACTER |
| nonNegativeInteger | DECIMAL |
| nonPositiveInteger | DECIMAL |
| normalizedString | CHARACTER |
| NOTATION | CHARACTER |
| positiveInteger | DECIMAL |
| QName | CHARACTER |
| short | INTEGER |
| string | CHARACTER |
| time | TIME |
| token | CHARACTER |
| unsignedByte | INTEGER |
| unsignedInt | INTEGER |
| unsignedLong | DECIMAL |
| unsignedShort | INTEGER |
| yearMonthDuration | INTERVAL |