MQSeries.net :: View topic - WMB7 - ESQL SET dynamic reference

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 » WMB7 - ESQL SET dynamic reference

WMB7 - ESQL SET dynamic reference

« View previous topic :: View next topic »

Author

Message

scravr

Posted: Wed Aug 10, 2011 12:48 pm Post subject: WMB7 - ESQL SET dynamic reference

Partisan

Joined: 03 Apr 2003
Posts: 391
Location: NY NY USA 10021

and HI to all,

I have ESQL compute node getting XML with the following elements:
1. ElementPpath: Pointing to other element by name:
<ElementPath>level1.level2.level3</ElementPath>

2. ReplaceValue:
<ReplaceValue>xyz</ReplaceValue>

3. Message to replace:
<MyMsgRootTag>
<level1>
<level2>
<level3>abc</level3>
...
...
...

How in ESQL can I dynamically replace abc with xyz?
I am looking for syntax that can replace any number of levels: level1 or level1.level2 or level1.level2.level3........

Thanks,
Mos

fjb_saper

Posted: Wed Aug 10, 2011 1:01 pm Post subject:

Grand High Poobah

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

relatively easy... Write a recursive proc that looks for either the tag or the content. If you return a reference to that result you can change it quite easily...

_________________
MQ & Broker admin

WGerstma

Posted: Wed Aug 10, 2011 3:08 pm Post subject:

Acolyte

Joined: 18 Jul 2011
Posts: 55

This, or you can try to concatenate a string with your ESQL command and execute it via EVAL

Display posts from previous:

Page 1 of 1

MQSeries.net Forum Index » WebSphere Message Broker (ACE) Support » WMB7 - ESQL SET dynamic reference

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