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

ESQL types and schema types

This topic shows the equivalent ESQL and schema data types.

The following table shows the mappings between the Schema type, the ESQL type, and the WebSphere® Message Broker tree type:

XML Schema simple type 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 List of CHARACTER
ENTITY STRING
float FLOAT
gDay DATE
gMonth DATE
gMonthDay DATE
gYear DATE
gYearMonth DATE
hexBinary BLOB
ID CHARACTER
IDREF CHARACTER
IDREFS List of CHARACTER
int INTEGER
integer DECIMAL
language CHARACTER
long INTEGER
Name CHARACTER
NCName CHARACTER
negativeInteger DECIMAL
NMTOKEN CHARACTER
NMTOKENS List of 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
Notices | Trademarks | Downloads | Library | Support | Feedback

Copyright IBM Corporation 1999, 2016Copyright IBM Corporation 1999, 2016.

        
        Last updated:
        
        Last updated: 2016-05-23 14:48:26


Reference topicReference topic | Version 8.0.0.7 | br28673_