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

messagebroker ibm-integration-bus extended-sql
Kenneth Lhv picture Kenneth Lhv · May 24, 2012 · Viewed 18.9k times · Source

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

Answer

Petter Nordlander picture Petter Nordlander · May 25, 2012

Try something like this:

CAST( MYLITTLESTRING AS BLOB CCSID InputRoot.Properties.CodedCharSetId)

Related questions

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 access and modify value of a particular element in ESQL. I worte following code.. CREATE PROCEDURE CopyEntireMessage() BEGIN --SET OutputRoot = …

Read More
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 then have to thow an user defined exception. This has to be achieved using ESQL. example : <input_data> &…

Read More
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 option field of output. Input: <feature>124414500045563879</feature> output: <option>124414</option> <option&…

Read More