MQSeries.net :: View topic - How to use the Create function to parse a BLOB to XML.

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 use the Create function to parse a BLOB to XML.

How to use the Create function to parse a BLOB to XML.

« View previous topic :: View next topic »

Author

Message

harih

Posted: Mon Nov 10, 2003 4:36 pm Post subject: How to use the Create function to parse a BLOB to XML.

Newbie

Joined: 10 Nov 2003
Posts: 1

Hi,

I have a BLOB message which I have to parse as XML. How do I use the Create Field with Parse command instead of an RCD node?

Thanks,
Hari

mpuetz

Posted: Mon Nov 10, 2003 5:07 pm Post subject:

Centurion

Joined: 05 Jul 2001
Posts: 149
Location: IBM/Central WebSphere Services

DECLARE ccsid, encoding INTEGER;
DECLARE yout_blob BLOB;

SET ccsid = 819; -- whatever the codepage of your XML
SET encoding = 273; -- whatever the encoding of your XML

SET your_blob = ...; -- whatever BLOB contains your XML

CREATE LASTCHILD OF OutputRoot NAME 'XML' DOMAIN 'XML' PARSE ( your_blob, ccsid, encoding);

This will create the folder XML with the correct parser name setting
which will then hold your parsed XML message.

Maybe I got the order of NAME and DOMAIN wrong and / or the
order of ccsid and encoding, but check your ESQL reference
to make sure.
_________________
Mathias Puetz

IBM/Central WebSphere Services
WebSphere Business Integration Specialist

Display posts from previous:

Page 1 of 1

MQSeries.net Forum Index » WebSphere Message Broker (ACE) Support » How to use the Create function to parse a BLOB to XML.

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