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 » WebSphere Message Broker (ACE) Support » Sorting and Removing Duplicates

Post new topic  Reply to topic Goto page Previous  1, 2
 Sorting and Removing Duplicates « View previous topic :: View next topic » 
Author Message
mqjeff
PostPosted: Wed May 04, 2011 7:45 am    Post subject: Reply with quote

Grand Master

Joined: 25 Jun 2008
Posts: 17447

Siva is starting from a message aggregation, that contains two messages in the logical message tree.

Siva then wants to combine these two messages into a single message that has the relevant data items sorted and any duplicates removed.

It may or may not at all be as simple as wanting to sort a single list of values.

It could, for example, be sorting a set of Person records by last name, where each Person record has many many fields in it that all need to be kept with the same record.

It is this kind of case that makes one really wish that ESQL SELECT had an ORDER BY clause.
Back to top
View user's profile Send private message
khudania
PostPosted: Wed May 04, 2011 7:48 am    Post subject: Reply with quote

Apprentice

Joined: 30 Nov 2004
Posts: 43

Siva, please if you could provide a sample of the message with some values and expected expected output.
_________________
If the doors of perception were cleansed, everything would appear as it is - infinite
Back to top
View user's profile Send private message
siva1431202
PostPosted: Wed May 04, 2011 9:02 pm    Post subject: Reply with quote

Novice

Joined: 04 May 2011
Posts: 20

Siva, please if you could provide a sample of the message with some values and expected expected output.


reply to this:

<Employees> <emp><empID>1</EmpID><last>Dill</last><first>Phil</first><salary>100000</salary></emp>
<emp><empID>2</EmpID><last>Bill</last><first>Fohnny</first><salary>95000</salary></emp>
<emp><empID>3</EmpID><last>Bill</last><first>Xraham</first><salary>89000</salary></emp>
<emp><empID>2</EmpID><last>Bill</last><first>Fohnny</first><salary>95000</salary></emp>
</Employees>

Firstly want this to be sorted using PHPComputenode and JavaCompute Nodes and then Duplicates should be removed from this.
Back to top
View user's profile Send private message
siva1431202
PostPosted: Wed May 04, 2011 9:03 pm    Post subject: Reply with quote

Novice

Joined: 04 May 2011
Posts: 20

Sorted Using First name and Remove Duplicates using EmpID.
Back to top
View user's profile Send private message
khudania
PostPosted: Thu May 05, 2011 1:14 am    Post subject: Reply with quote

Apprentice

Joined: 30 Nov 2004
Posts: 43

See the example by Fou-Lu, this is exactly what you have described.

http://www.codingforums.com/archive/index.php/t-43014.html
_________________
If the doors of perception were cleansed, everything would appear as it is - infinite
Back to top
View user's profile Send private message
siva1431202
PostPosted: Thu May 05, 2011 8:54 pm    Post subject: Reply with quote

Novice

Joined: 04 May 2011
Posts: 20

Ok Thank you. I am trying to build with the code which you have given.
Back to top
View user's profile Send private message
Display posts from previous:   
Post new topic  Reply to topic Goto page Previous  1, 2 Page 2 of 2

MQSeries.net Forum Index » WebSphere Message Broker (ACE) Support » Sorting and Removing Duplicates
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
 
 


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

Copyright © MQSeries.net. All rights reserved.