MQSeries.net :: View topic - How to conver between XML and String in ESQL

MQSeries.net

Tech Exchange

Education

Certifications

Library

Info Center

SupportPacs

FAQÂ Â

Usergroups

RSS Feed - WebSphere MQ Support

RSS Feed - Message Broker Support

MQSeries.net Forum Index » WebSphere Message Broker (ACE) Support » How to conver between XML and String in ESQL

How to conver between XML and String in ESQL

« View previous topic :: View next topic »

Author

Message

leo.yue

Posted: Wed Oct 20, 2004 7:03 am Post subject: How to conver between XML and String in ESQL

Acolyte

Joined: 20 Oct 2004
Posts: 52

I have a MQInput Node, and it's domain is "XML".

I get a message (xml format) from queue, and I want to store it in db.

But how can i get string format from xml form?
And next time, I get this string from db, how can I convet it to XML.

example:
<book>
Message Broker
</book>

I want to convert 'Output.XML' to string [<book>Message Broker</book>]
and convert string [<book>Message Broker</book>] to 'Output.XML'

How can I do ? thanks

I use Message Broker 5 csd03

jefflowrey

Posted: Wed Oct 20, 2004 7:23 am Post subject:

Grand Poobah

Joined: 16 Oct 2002
Posts: 19981

What are you trying to accomplish?
_________________
I am *not* the model of the modern major general.

leo.yue

Posted: Wed Oct 20, 2004 7:28 am Post subject:

Acolyte

Joined: 20 Oct 2004
Posts: 52

Thank you for your reply

I want to store an entire xml message in db2 .
And in some situation, I will read it from db and handle it

jefflowrey

Posted: Wed Oct 20, 2004 7:30 am Post subject:

Grand Poobah

Joined: 16 Oct 2002
Posts: 19981

Use ASBITSTREAM.

And CREATE FIELD ... PARSE to go the other way.
_________________
I am *not* the model of the modern major general.

Posted: Wed Oct 20, 2004 7:33 am Post subject:

Padawan

Joined: 27 Mar 2003
Posts: 1564
Location: Hartford, CT.

This topic has been addressed many times in this forum. Performing a search on this site using the criteria: XML and STRING and DATABASE will result in dozens of matches.

Additionally, searching for ASBITSTREAM will prove helpful to you.

leo.yue

Posted: Wed Oct 20, 2004 7:50 am Post subject:

Acolyte

Joined: 20 Oct 2004
Posts: 52

Thanks!

I have searched these topics. But I can not find how to convert string to XML (Output.XML)

Posted: Wed Oct 20, 2004 8:00 am Post subject:

Padawan

Joined: 27 Mar 2003
Posts: 1564
Location: Hartford, CT.

The title of this one is String to XML: http://www.mqseries.net/phpBB2/viewtopic.php?t=17027

Display posts from previous:

Page 1 of 1

MQSeries.net Forum Index » WebSphere Message Broker (ACE) Support » How to conver between XML and String in ESQL

Jump to:

You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum

Protected by Anti-Spam ACP