MQSeries.net :: View topic - How to handle for fetching multiple records use computenode

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 » How to handle for fetching multiple records use computenode

How to handle for fetching multiple records use computenode

« View previous topic :: View next topic »

Author

Message

mahesh4eai

Posted: Sat Aug 09, 2014 10:15 pm Post subject: How to handle for fetching multiple records use computenode

Novice

Joined: 09 Aug 2014
Posts: 21

Hi, I am using the compute node for fetching multiple records in database.For example we are passing the from date (2014-06-06) in request xml.For that particular date multiple records(more than 1000) are there in database how will we handle the situation.In this case is the right way to use the compute node?Some one pls suggest for me how to handle this situation.

Vitor

Posted: Tue Aug 12, 2014 4:52 am Post subject: Re: How to handle for fetching multiple records use computen

Grand High Poobah

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

mahesh4eai wrote:

how will we handle the situation.

The same way you would handle a multiple row result set in any programming language, and depending very much on what you're doing with the result set. If (for example) you want to process some kind of aggregated data (like the total of some value, or the number of results in each of a list of business classes) then you might want to itterate through the result set within that node. If (for example) you wish to process each row into data being sent to a downstream process then you could send each row as a discrete message forward through the flow, or indeed to a separate flow to permit load balanced parallel processing.

There is of course no reason why you couldn't elect to perform parallel processing and use one of the advertised techniques to generate agregated data. The decision of what you're actually going to do is called "design", and is specific to your distinct needs and requirements.
_________________
Honesty is the best policy.
Insanity is the best defence.

Display posts from previous:

Page 1 of 1

MQSeries.net Forum Index » WebSphere Message Broker (ACE) Support » How to handle for fetching multiple records use computenode

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