MQSeries.net :: View topic - Way to change for every row a columns value without loop...

MQSeries.net

Tech Exchange

Education

Certifications

Library

Info Center

SupportPacs

FAQÂ Â

Usergroups

RSS Feed - WebSphere MQ Support

RSS Feed - Message Broker Support

MQSeries.net Forum Index » WebSphere Message Broker (ACE) Support » Way to change for every row a columns value without loop...

Way to change for every row a columns value without loop...

« View previous topic :: View next topic »

Author

Message

klabran

Posted: Mon Aug 28, 2006 2:53 pm Post subject: Way to change for every row a columns value without loop...

Master

Joined: 19 Feb 2004
Posts: 259
Location: Flagstaff AZ

I have an xml message whereby a certain section is repeating. For a particular column in each row I would like to change the value for to a constant. Is there a way to do this without looping through the list....

Currently I am doing...

Code:

DECLARE intCharges INTEGER CARDINALITY(OutputRoot.XML.cjs_Report.Booking.Suspect.SuspectCharge[]);
WHILE intCntr <= intCharges DO
SET OutputRoot.XML.cjs_Report.Booking.Suspect.SuspectCharge[intCntr].ChargeClassification."j:ChargeSeverityText" = 'M';
SET intCntr = intCntr + 1;
END WHILE;

Is there a way to do this without looping?

jefflowrey

Posted: Mon Aug 28, 2006 3:00 pm Post subject:

Grand Poobah

Joined: 16 Oct 2002
Posts: 19981

You can't do UPDATEs on message trees, alas.

You can improve the performance quite a bit by using a reference instead of a counter.
_________________
I am *not* the model of the modern major general.

mgk

Posted: Tue Aug 29, 2006 2:34 am Post subject:

Padawan

Joined: 31 Jul 2003
Posts: 1642

Hi,

You could try SELECT.

Regards,
_________________
MGK
The postings I make on this site are my own and don't necessarily represent IBM's positions, strategies or opinions.

klabran

Posted: Tue Aug 29, 2006 6:07 am Post subject:

Master

Joined: 19 Feb 2004
Posts: 259
Location: Flagstaff AZ

thanks...

Display posts from previous:

Page 1 of 1

MQSeries.net Forum Index » WebSphere Message Broker (ACE) Support » Way to change for every row a columns value without loop...

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