MQSeries.net :: View topic - using function SUM in verb application-specific info

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 Interchange Server + Adapters » using function SUM in verb application-specific info

using function SUM in verb application-specific info

« View previous topic :: View next topic »

Author

Message

sirsi

Posted: Thu May 25, 2006 1:42 pm Post subject: using function SUM in verb application-specific info

Disciple

Joined: 11 Mar 2005
Posts: 177

Hi,
Can i specify soemthing like "SUM(column)" in verb application-specific information for 'Retrieve' in a BO. Basically i want a retrieve query to be generated as "select col1 from table where SUM(col2) > 10".

If this is not possible then, is there any other way apart from using stored procedures?

sirsi

Posted: Fri May 26, 2006 10:52 am Post subject:

Disciple

Joined: 11 Mar 2005
Posts: 177

got to know that we cant use aggregate functions directly inside WHERE clause... you need to use it with GROUP, HAVING clause...

i am planning to use stored procedure for doing this....

Display posts from previous:

Page 1 of 1

MQSeries.net Forum Index » WebSphere Interchange Server + Adapters » using function SUM in verb application-specific info

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