MQSeries.net :: View topic - Transformation 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 » Transformation in ESQL

Transformation in ESQL

« View previous topic :: View next topic »

Author

Message

chenna.hari

Posted: Mon Dec 27, 2010 9:22 pm Post subject: Transformation in ESQL

Centurion

Joined: 21 Mar 2009
Posts: 103

Hi,

I need to generate the output containing the element names as same as Values of Elements present in input xml.

for example input xml is

Quote:

<input>
<Element1>Name</Element1>
<Element2>Value</Element2>
</input>

output xml is

Quote:

<output>
<Name>Value</Name>
<output>

Any suggestions pls??

fjb_saper

Posted: Mon Dec 27, 2010 9:33 pm Post subject:

Grand High Poobah

Joined: 18 Nov 2003
Posts: 20756
Location: LI,NY

Check the ESQL reference and the manuals (programmer)... it's all in there.
Look up things like

Code:

Set myref.{"element1"} = value1;

Have fun

_________________
MQ & Broker admin

chenna.hari

Posted: Tue Dec 28, 2010 2:11 am Post subject:

Centurion

Joined: 21 Mar 2009
Posts: 103

Thanks a lot for solution.

kash3338

Posted: Wed Dec 29, 2010 12:57 am Post subject:

Shaman

Joined: 08 Feb 2009
Posts: 709
Location: Chennai, India

fjb_saper wrote:

Check the ESQL reference and the manuals (programmer)... it's all in there.
Look up things like

Code:

Set myref.{"element1"} = value1;

Have fun

One more way of doing this is using the EVAL statement. Check the manuals for the same.

mqjeff

Posted: Wed Dec 29, 2010 7:19 am Post subject:

Grand Master

Joined: 25 Jun 2008
Posts: 17447

kash3338 wrote:

One more way of doing this is using the EVAL statement. Check the manuals for the same.

Yep, but much less efficient.

Display posts from previous:

Page 1 of 1

MQSeries.net Forum Index » WebSphere Message Broker (ACE) Support » Transformation 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