MQSeries.net :: View topic

abiram8 · Posted: Sun Oct 20, 2002 5:33 am Post subject:

Hi,

Iam testing the Publish - Subscribe using ESQL in my Publish Node using compute node as follows My Publisher Compute Node is as follows

I have selected the option of Selecting (* Copy Message Header )

-- Enter SQL below this line. SQL above this line might be regenerated, causing any modifications to be lost.

Case 2)

SET OutputRoot.MQMD=InputRoot.MQMD;
SET OutputRoot.MQRFH2.psc.Command='Publish';
SET OutputRoot.MQRFH2.psc.Topic='COPS-REPLY';
SET OutputRoot = InputRoot; <<<<<<<<<<<==== here it comes Last

I have my peace of trace node shows me as below

UserTrace BIP7086I: Node 'SERVERPUBLISH.Publication1.PSService1': The Publication Node with Subscription Point '' has received an error code 2339.

the explanation for 2339 is as given in the doccument

MQRC_RFH_PARM_MISSING

Some parameters within <psc>or <mcd>
folders are optional and can be omitted;
some are mandatory and must not be
omitted. Check that you have included
all mandatory parameters within your
<psc>and <mcd>folders.
**********************************************************************************

This is the error description but if I try my Compute node ESQL as shown below

I have selected the option of Selecting (* Copy Message Header )

-- Enter SQL below this line. SQL above this line might be regenerated, causing any modifications to be lost.

Case 1)

SET OutputRoot = InputRoot; <<<<<<<<<<<==== here it comes first
SET OutputRoot.MQMD=InputRoot.MQMD;
SET OutputRoot.MQRFH2.psc.Command='Publish';
SET OutputRoot.MQRFH2.psc.Topic='COPS-REPLY';

In this I never get the Error & my Subscriber Q gets the Message published by Publisher

Iam trying case 1 since in that case I want my Messsage will come after MQRFH2 headers but in case 2 I donot want because My message arrives before MQRFH2 & my retriving program message.seek(int) will not work

I donot understand why changing the SET OutputRoot = InputRoot; results in 2339 error

All type of Ideas are welcome or If some one can please let me know how how to write the Publication node in ESQL so that I can get Message after MQRFH2 Header in the subcribing Queue

Thanks

R.Abiram