Top "Extended-sql" questions

IBM Integration Bus (IIB) specifies Extended Structured Query Language (ESQL) as a programming language used to define and manipulate data within a message flow.

How to cast(convert) string to blob? in ESQL?

So i am reading an XML file from request note of flow. And need to convert XML data to blob.

messagebroker ibm-integration-bus extended-sql
Websphere Message Broker: Accessing XML elements in ESQL

Websphere Message Broker: File in File out example. I have an XML file with repeating element structure. How can I …

xml ibm-mq messagebroker ibm-integration-bus extended-sql
CURRENT_TIME format in esql

What is the default format of the function CURRENT_TIME in esql and how do we change it as per …

ibm-integration-bus extended-sql
ESQL : Check One of the incoming xml tag contains serialzed data

Need help to validate if one of the incoming XML tag contains serialized data or not. If ir doesn't contain …

messagebroker ibm-integration-bus extended-sql
ESQL for splitting a string into mulitple values

Following Input xml field needs to be substringed for 6 characters and each 6 characters should be splitted and saved in the …

messagebroker ibm-integration-bus extended-sql
WMB ESQL passing constants to passthru

I am working on IBM Websphere Message Broker v6.0 and writing a message flow in ESQL. I am using passthru …

ibm-integration-bus extended-sql
Esql how to use select statement to retrieve value from input xml

I have an input xml that looks something like this <log> <line> <id>1</…

xml select ibm-integration-bus extended-sql
Building MQMD header in compute node of IBM message broker

I'm having trouble trying to add MQMD header in compute node. Tried something like that: SET OutputRoot.Properties = InputRoot.Properties; …

ibm-mq messagebroker ibm-integration-bus extended-sql