MQSeries.net :: View topic - How to get the bunch of records from DB using ESQL?

Smarty05 · Posted: Mon Oct 13, 2008 3:42 am Post subject:

Hi,

We have a requirement where we need to get the XML messages from DB2 tables for Status code 'E' and generate the MQ message and put it into the reprocessing flow input queue.

My SELECT query may result in 1000+ records (XMLs) with Status code'E" , which may be performance overhead when i take the result set in Enviornment.Variable.DBResult.

So wanted to know, is there a way to get DB records in bunch of 50 using ESQL or SELECT query and do the processing?

Your suggestions are very much appreciated.

Thanks in advance..