thanks a lot chris,amit.....will get to it... > -----Original Message----- > From: Christopher Frank [SMTP:[EMAIL PROTECTED]] > Sent: Wednesday, June 12, 2002 9:58 PM > To: [EMAIL PROTECTED] > Subject: Re: Propogate function in MQSI 2.1??? > > Adi, > > >>>We were using MQSI 2.0.1 till some time back and we > >>>picked up data from the DB and generated a common single > >>>XML message for all the reccords and used the SQL4j parser > >>>API's to break these into individual XML's for each record > >>>through a triggered java program.However,I was told by a > >>>MQ guru that in MQSI 2.1 this breaking down can be performed > >>>by MQSI itself and he mentioned the propogate ESQL function > >>>in the same context.Anyone has any ideas on this? > > Your MQ guru is correct. When used in a Compute or Database node, the > PROPAGATE statement introducted in WMQI V2.1 allows you to emit one or > more > output message trees to downstream nodes within the message flow. > > So you could pick up your data from the DB, and use a while loop to break > up the data into individual XML messages representing each record, like > so: > > DECLARE i INTEGER; > SET i =1; > WHILE i <=CARDINALITY(<repeating_records>[])DO > SET OutputRoot =InputRoot; > SET OutputRoot.XML =NULL; > SET OutputRoot.XML.<record>[i ]; > PROPAGATE; > SET i =i+1; > END WHILE; > RETURN FALSE; > > Used in a Compute or Database node, this would loop through a tree > structure of repeating records, and on each iteration emit a message tree > representing an individual record. The "RETURN FALSE" is used because by > default the Compute node automatically propagates a message tree to its > downstream node when its eSQL terminates. "RETURN FALSE" will prevent this > from occuring. > > Regards, > > Christopher Frank > Sr. I/T Specialist - IBM Software Group > IBM Certified Solutions Expert - Websphere MQ & MQ Integrator > -------------------------------------------- > Phone: 612-397-5532 (t/l 653-5532) mobile: 612-669-3008 > e-mail: [EMAIL PROTECTED] > > Instructions for managing your mailing list subscription are provided in > the Listserv General Users Guide available at http://www.lsoft.com > Archive: http://vm.akh-wien.ac.at/MQSeries.archive
Instructions for managing your mailing list subscription are provided in the Listserv General Users Guide available at http://www.lsoft.com Archive: http://vm.akh-wien.ac.at/MQSeries.archive
