ASG
IBM
Zystems
Cressida
Icon
Netflexity
 
  MQSeries.net
Search  Search       Tech Exchange      Education      Certifications      Library      Info Center      SupportPacs      LinkedIn  Search  Search                                                                   FAQ  FAQ   Usergroups  Usergroups
 
Register  ::  Log in Log in to check your private messages
 
RSS Feed - WebSphere MQ Support RSS Feed - Message Broker Support

MQSeries.net Forum Index » WebSphere Message Broker (ACE) Support » AggregateReply - Building Final Output- MQMD problem

Post new topic  Reply to topic
 AggregateReply - Building Final Output- MQMD problem « View previous topic :: View next topic » 
Author Message
Thripura Sundari
PostPosted: Wed Jul 20, 2005 6:08 am    Post subject: AggregateReply - Building Final Output- MQMD problem Reply with quote

Acolyte

Joined: 13 Jun 2005
Posts: 57
Location: Bangalore, India

Hi all,
I dont understand what
Quote:
InputRoot.ComIbmAggregateReplyBody.MQMD
does. I am trying to place the contents of two XMLs input to the AggregateReply node into one root node of the Output XML. I tried out the following code, but I get the exception that the MQMD of the message is not formed.

Seeing the Airline example given in the software, I tried to create the first child. But dont we

Code:

CREATE COMPUTE MODULE RequestQueryInMsgFlow_Compute
   CREATE FUNCTION Main() RETURNS BOOLEAN
   BEGIN

CREATE FIELD OutputRoot.XML.CruiseAvailabilityOutput;
DECLARE MyOutput REFERENCE TO OutputRoot.XML.CruiseAvailabilityOutput;

CREATE FIELD OutputRoot.XML.CruiseAvailabilityOutput.CruiseA;
CREATE FIELD OutputRoot.XML.CruiseAvailabilityOutput.CruiseB;

DECLARE Cruise1 REFERENCE TO InputRoot.ComIbmAggregateReplyBody.CruiseA.XML.Cruise1;
DECLARE Cruise2 REFERENCE TO InputRoot.ComIbmAggregateReplyBody.CruiseA.XML.Cruise2;

CREATE FIRSTCHILD OF OutputRoot.XML.CruiseAvailabilityOutput;
SET MyOutput.CruiseA=Cruise1;
SET MyOutput.CruiseB=Cruise2;

   END;
END MODULE;


I am getting invalid MQMDException. and the body of the ComIbmAggregateReplyBody with in the output file (as seen in the flow debugmessage)...

Can some one please tell me what is wrong with the ESQL (I amjust learning, so, may be I have gone wrong somewhere in the basics...) I dont want the ComIbmAggregateReplyBody containing the folders for both the requests, to be present in the output xml.

If any more information is required, I can send via mail.
Thanks.
Regards,
Thripura Sundari
Back to top
View user's profile Send private message
lillo
PostPosted: Wed Jul 20, 2005 11:25 pm    Post subject: Reply with quote

Master

Joined: 11 Sep 2001
Posts: 224

Add the following two lines before your first CREATE FIELD statement in your ESQL code to create the MQMD.
Code:
SET OutputRoot.MQMD.StrucId=MQMD_STRUC_ID;
SET OutputRoot.MQMD.Version=MQMD_CURRENT_VERSION;

_________________
Lillo
IBM Certified Specialist - WebSphere MQ
Back to top
View user's profile Send private message
Thripura Sundari
PostPosted: Thu Jul 21, 2005 1:49 am    Post subject: Reply with quote

Acolyte

Joined: 13 Jun 2005
Posts: 57
Location: Bangalore, India

Hi,
Thanks for the response. I set the MQMD structure with the code you gave. I didnot get any exception, but I was continuing to get both the contents of the ComIbmAggregateReplyBody containing both the folders etc. So, I made the ESQL code as

Code:

DECLARE Cruise1 REFERENCE TO InputRoot.ComIbmAggregateReplyBody.OFFLINE1REQUESTFDR.XML.Cruise1;
DECLARE Cruise2 REFERENCE TO InputRoot.ComIbmAggregateReplyBody.OFFLINE2REQUESTFDR.XML.Cruise2;

CREATE FIRSTCHILD OF OutputRoot.XML.CruiseAvailabilityOutput;
SET OutputRoot.XML.CruiseAvailabilityOutput.CruiseA = Cruise1;
SET OutputRoot.XML.CruiseAvailabilityOutput.CruiseB = Cruise2;


I dont know whether this is correct or it is a manipulation. If there is a better way, can some one please let me know.
Thanks a lot for all the help.

Regards,
Thripura Sundari
Back to top
View user's profile Send private message
Display posts from previous:   
Post new topic  Reply to topic Page 1 of 1

MQSeries.net Forum Index » WebSphere Message Broker (ACE) Support » AggregateReply - Building Final Output- MQMD problem
Jump to:  



You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum
Protected by Anti-Spam ACP
 
 


Theme by Dustin Baccetti
Powered by phpBB © 2001, 2002 phpBB Group

Copyright © MQSeries.net. All rights reserved.