MQSeries.net :: View topic

pyrus · Posted: Mon Apr 19, 2010 2:15 am Post subject:

Hello,

I have been searching and trying for a while now and I can't seem to find the solution to my problem unless I code something really complicated which will probably not be very performant.

I receive a tab delimited message (MRM) and this contains only 2 different rows. One row is the header the other is a repeating detail row. These detail rows come in with a specific order and I want to order (asc/desc doesn't matter) or group them so that all rows with the same itemnumber are grouped.

e.g: if I get these itemnumbers 13232123 the result should be 11222333

Now I have tried to use a SELECT statement on my InputRoot but the normal SELECT statement in ESQL does not allow an ORDER BY/GROUP BY clause. I did find the solution to that, being the PASSTHRU function, unfortunately that only seems to accept actual databases to select from....

sigh...

Does anybody know of some way to do this with the supplied logic of the 6.1 broker? I don't want to write a complete new function for this unless I really need to.

The only other way I think might be kind of clean is mapping the MRM to the exact same MRM structure but using a mapping node and the sorting option within that.