MQSeries.net :: View topic - ESQL (XML header) question

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 » ESQL (XML header) question

ESQL (XML header) question

« View previous topic :: View next topic »

Author

Message

Gideon

Posted: Wed Mar 10, 2010 3:25 pm Post subject: ESQL (XML header) question

Chevalier

Joined: 18 Aug 2009
Posts: 403

I have an input XML that I send to an ESQL compute node, with the following header at the very top of the XML

Code:

<?xml version="1.0" encoding="utf-8"?>

My ESQL extracts the data from the input XML very well, but I can not seem to extract that very first xml header

I tried the following code, but it does not work

Code:

SET OutputRoot.XMLNSC."?xml".(XMLNSC.Attribute)version='1.0';
SET OutputRoot.XMLNSC."?xml".(XMLNSC.Attribute)encoding='utf-8';

(Wehn I get the commands to work I will extract the version and encoding directly from the input message).

How can I create this top line in the XML ?

Thanks

Vitor

Posted: Wed Mar 10, 2010 7:48 pm Post subject: Re: ESQL (XML header) question

Grand High Poobah

Joined: 11 Nov 2005
Posts: 26093
Location: Texas, USA

Gideon wrote:

How can I create this top line in the XML ?

As shown here
_________________
Honesty is the best policy.
Insanity is the best defence.

kimbert

Posted: Thu Mar 11, 2010 5:25 am Post subject:

Jedi Council

Joined: 29 Jul 2003
Posts: 5542
Location: Southampton

You could have found the answer for yourself this way:
- create a small flow with an input node followed by a Trace node.
- set the pattern on the Trace node to ${Root}
- create the XML document that you want your flow to write
- put that XML document through the flow
- examine InputRoot.XMLNSC in the trace node output
- write ESQL which reproduces the same tree in OutputRoot.XMLNSC

I suggest that you try this technique on this problem - it's really simple, and well worth doing. It might be possible to do the same using the debugger, but I'm not sure whether the debugger shows you the field type names.

Display posts from previous:

Page 1 of 1

MQSeries.net Forum Index » WebSphere Message Broker (ACE) Support » ESQL (XML header) question

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