MQSeries.net :: View topic - looping through a node

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 » looping through a node

looping through a node

« View previous topic :: View next topic »

Author

Message

kt76

Posted: Sun Jan 18, 2004 11:06 pm Post subject: looping through a node

Acolyte

Joined: 18 Jan 2004
Posts: 52

I have the following requirement:

I may get multiple data values in a tag from my calling application to the broker:

eg:
<inputdata>
a
b
c
d
.....
</inputdata>

For each value in <inputag>, i need to call a subflow to get me some values from the database. Once all values recd, i need to aggregate this and send it to the calling application.

How can this be achieved? i am using WMQI ver5.0.1

zpat

Posted: Mon Jan 19, 2004 3:47 am Post subject:

Jedi Council

Joined: 19 May 2001
Posts: 5866
Location: UK

You can loop around calling subflows by "wiring" the loop in the control centre with multiple nodes and using a filter node to decide when the loop had ended.

However with V5 you can call ESQL subroutines and/or functions so that a more conventional programming loop in a Compute node might be easier.

kimbert

Posted: Mon Jan 19, 2004 4:18 am Post subject:

Jedi Council

Joined: 29 Jul 2003
Posts: 5542
Location: Southampton

Quote:

However with V5 you can call ESQL subroutines and/or functions so that a more conventional programming loop in a Compute node might be easier.

...not only easier, but it will perform *much* better. Ideally, generate a single database query from the input message. If the result set is sorted, you should be able to loop around it and do whatever you need in ESQL.

kt76

Posted: Mon Jan 19, 2004 7:08 am Post subject:

Acolyte

Joined: 18 Jan 2004
Posts: 52

DOes anyone have any sample code or pointers to a redbook which shows how this can be done.

Display posts from previous:

Page 1 of 1

MQSeries.net Forum Index » WebSphere Message Broker (ACE) Support » looping through a node

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