MQSeries.net :: View topic

francoisvdm · Posted: Mon Jul 21, 2008 1:27 am Post subject:

I would like to do two selects, one after the other but the second one must ADD to the result of the first one.

So after first select that returns 2 rows I would like to see:

Environment.Answer.Row[1] = 11111
.Row[2] = 22222

and after second select (3 rows) the Env should look like

Environment.Answer.Row[1] = 11111
.Row[2] = 22222
.Row[3] = abc
.Row[4] = def
.Row[5] = xyz

My first select looks like:
SET Environment.Answer.Row[] = SELECT P.MSG_ID FROM Database.EAI AS P WHERE P.MSG_ID = MSGID;

I would like the second to look something like:

SET Environment.Answer.Row[Current Row items] = SELECT P.MSG_ID FROM Database.EAI AS P WHERE P.MSG_ID = MSGID;

but hey, this does not work....anybody with any ideas?

Thanks
_________________
If you do not know the answer or you get the urge to answer with "RTFM" or "Search better in this forum", please refrain from doing so, just move on to the next question. Much appreciated.

Francois van der Merwe