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 » Search

 Search found 3 matches
Author Message
  Topic: Implementing Select Distinct or Group by in ESQL
bhavya.work

Replies: 10
Views: 7097
 PostForum: WebSphere Message Broker (ACE) Support   Posted: Wed Feb 24, 2016 9:28 pm   Subject: Implementing Select Distinct or Group by in ESQL
First Post, sorry if I break any forum rules. Well, actually you did, and sincere thanks for breaking at least two rules that most people follow. You actually cared about the person trying to understa ...
  Topic: Implementing Select Distinct or Group by in ESQL
bhavya.work

Replies: 10
Views: 7097
 PostForum: WebSphere Message Broker (ACE) Support   Posted: Wed Feb 24, 2016 1:24 pm   Subject: Implementing Select Distinct or Group by in ESQL
You remember right. There is no group by and distinct. It is clearly mentioned in documentation.

I think the approach of creating distinctName tree in env will probably work. Will have to try out. ...
  Topic: Implementing Select Distinct or Group by in ESQL
bhavya.work

Replies: 10
Views: 7097
 PostForum: WebSphere Message Broker (ACE) Support   Posted: Wed Feb 24, 2016 1:02 pm   Subject: Implementing Select Distinct or Group by in ESQL
First Post, sorry if I break any forum rules.

Goal : Split messages with distinct values. In example below x/xtypes/xtype/xtypeName is the distinct and group by element

Input Mesage:
<x> ...
Page 1 of 1

Jump to:  
Protected by Anti-Spam ACP
  
 


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

Copyright © MQSeries.net. All rights reserved.