MQSeries.net :: View topic - Distinct values from ESQL SELECT statement

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 » Distinct values from ESQL SELECT statement

Distinct values from ESQL SELECT statement

« View previous topic :: View next topic »

Author

Message

suraj

Posted: Fri Jun 13, 2008 10:09 am Post subject: Distinct values from ESQL SELECT statement

Acolyte

Joined: 31 Jul 2007
Posts: 56

Hi,

I am working on MB v6.1
I have a requirement in which i have to get the distinct value of an element in an XML message.
I am using the SELECT statement which gives me all the values of that element in the XML and then i had to eleminate the same values from the result using a separate while loop.
Is there any way that i can get the distinct values from the esql SELECT statement itself, like the DISTINCT clause we have in most of the database SQLs ?

sunny_30

Posted: Fri Jun 13, 2008 10:37 am Post subject:

Master

Joined: 03 Oct 2005
Posts: 258

try from esql:
"select disctinct" as the same way you did just "select"?

suraj

Posted: Fri Jun 13, 2008 10:44 am Post subject:

Acolyte

Joined: 31 Jul 2007
Posts: 56

i tried that, the DISTINCT is not a keyword. It flags an error on this.
Moreover its mentioned in the information center that this SELEECT does not support DISTINCT

Display posts from previous:

Page 1 of 1

MQSeries.net Forum Index » WebSphere Message Broker (ACE) Support » Distinct values from ESQL SELECT statement

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