MQSeries.net :: View topic - Alternative solution to DISTINCT possible?

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 » Alternative solution to DISTINCT possible?

Alternative solution to DISTINCT possible?

« View previous topic :: View next topic »

Author

Message

akidase

Posted: Thu Feb 17, 2011 3:38 am Post subject: Alternative solution to DISTINCT possible?

Centurion

Joined: 10 Jan 2011
Posts: 124

If I have something like

Code:

SET OutputRoot.XMLNSC.Root.Number[1]='1';
SET OutputRoot.XMLNSC.Root.Number[2]='1';
SET OutputRoot.XMLNSC.Root.Number[3]='1';

and I want to have the distinct rows in the set, Can somebody help ? ESQL/Java anything would help.

Functionality something like this...

Code:

SET OutputRoot.XMLNSC.Root.Number[]=SELECT distinct FROM OutputRoot.XMLNSC.Root.Number[];

mqjeff

Posted: Thu Feb 17, 2011 7:02 am Post subject:

Grand Master

Joined: 25 Jun 2008
Posts: 17447

ESQL Select doesn't have a DISTINCT clause.

You need to code this yourself.

There might be an option to do this with an XPath query, but I don't know off the top of my head if it allows element value comparisons.

Display posts from previous:

Page 1 of 1

MQSeries.net Forum Index » WebSphere Message Broker (ACE) Support » Alternative solution to DISTINCT possible?

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