MQSeries.net :: View topic - ESQL string variables :share a statement w diff app msg

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 string variables :share a statement w diff app msg

ESQL string variables :share a statement w diff app msg

« View previous topic :: View next topic »

Author

Message

jklow

Posted: Tue May 06, 2003 1:49 am Post subject: ESQL string variables :share a statement w diff app msg

Newbie

Joined: 21 Apr 2003
Posts: 7

Suppose I have a compute node for used by three different applications

APPLICATION A MESSAGE
<APPA>
<GENINFO>
<MYVALUE>123<MYVALUE>
</GENINFO>
</APPA>

APPLICATION B MESSAGE
<APPB>
<GENINFO>
<MYVALUE>678<MYVALUE>
</GENINFO>
</APPB>

APPLICATION C MESSAGE
<APPC>
<GENINFO>
<MYVALUE>798<MYVALUE>
</GENINFO>
</APPC>

extracting the <APPA>, <APPB> or <APPC> for APPLICATION_NAME

can i do value substitution in such case as shown below

SET txt = "InputBody".APPLICATION_NAME."GENINFO"."MYVALUE";

any possible way to make such string manupilation?

EddieA

Posted: Tue May 06, 2003 5:22 am Post subject:

Jedi

Joined: 28 Jun 2001
Posts: 2453
Location: Los Angeles

Depends of the version and/or CSD level as to how you do this.

Either use an EVAL , or the { ... } method for runtime substitution. The latter is MUCH more efficient.

Cheers,
_________________
Eddie Atherton
IBM Certified Solution Developer - WebSphere Message Broker V6.1
IBM Certified Solution Developer - WebSphere Message Broker V7.0

jklow

Posted: Tue May 06, 2003 7:02 pm Post subject: EVAL : Not a valid compute expression

Newbie

Joined: 21 Apr 2003
Posts: 7

I used EVAL as following :

EVAL('SET myValue=
InputBody.'||APPLICATION_NAME||'.GENINFO.myVALUE;');

but the editor within the compute node complain about :
syntax error -> Not a valid compute expression

I am using MQSI 2.0.2 ...

Is this to mean that EVAL is not available for this version?

fschofer

Posted: Wed May 07, 2003 1:30 am Post subject:

Knight

Joined: 02 Jul 2001
Posts: 524
Location: Mainz, Germany

Hi,
you can also use anonymous field references to adress the children of "APPLICATION_NAME"

SET txt = "InputBody".*[1]."GENINFO"."MYVALUE";

So you can use the same ESQL for all messages.

Display posts from previous:

Page 1 of 1

MQSeries.net Forum Index » WebSphere Message Broker (ACE) Support » ESQL string variables :share a statement w diff app msg

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