| Author |
Message
|
| MQMD |
 Posted: Thu May 03, 2007 9:26 am Post subject: Reseting ReplyToQ Field in MQMD Header |
 |
|
Apprentice
Joined: 03 May 2007
Posts: 45
|
I am trying to reset ReplytoQ field in MQMD header as below
SET OutputRoot.MQMD.ReplyToQ = THE ( ITEM SELECT T.ServiceResQ FROM Database.{Source1}.{Schema1}.{Table1} AS T WHERE T.Service = 'SERVICENAME');
This is deleting the ReplyToQ field from MQMD header.As shown in Trace snippet
(0x03000000):MsgId = X'414d51204449414d4f4e445f4d475220c85238462001e302'
(0x03000000):CorrelId = X'000000000000000000000000000000000000000000000000'
(0x03000000):BackoutCount = 0
(0x03000000):ReplyToQMgr = 'APPLICATION_MGR '
(0x03000000):UserIdentifier = '202546 '
(0x03000000):AccountingToken = X'16010515000000703c229ac8d01ec317cd09e4d272000000000000000000000b'
Also It is corrupting the MQMD header as shown in exception 'Failed to put message'.
Please suggest the corrective action. |
|
| Back to top |
|
 |
| jefflowrey |
| Posted: Thu May 03, 2007 9:28 am Post subject: |
|
|
Grand Poobah
Joined: 16 Oct 2002
Posts: 19981
|
What happens if your SELECT returns NULL?
_________________
I am *not* the model of the modern major general. |
|
| Back to top |
|
|
| MQMD |
| Posted: Thu May 03, 2007 9:32 am Post subject: |
|
|
Apprentice
Joined: 03 May 2007
Posts: 45
|
| Thanks jeff. Would check the cardinality.Is there any other thing possible. |
|
| Back to top |
|
|
| jefflowrey |
| Posted: Thu May 03, 2007 9:36 am Post subject: |
|
|
Grand Poobah
Joined: 16 Oct 2002
Posts: 19981
|
Many other things are possible. What's likely, I can't say.
_________________
I am *not* the model of the modern major general. |
|
| Back to top |
|
|
| MQMD |
| Posted: Thu May 03, 2007 9:46 am Post subject: |
|
|
Apprentice
Joined: 03 May 2007
Posts: 45
|
| Thanks Jeff . that was the problem .It's resolved. |
|
| Back to top |
|
|
|
|
