Announcement:
wanna exchange links? contact me at sapchatroom@gmail.com.
Posted by
Admin at
Hi Randysy,
Structure of cluster is handled in application server. SQL server has no such information and therefore it can return only whole record which matches the table key. After it the application server can apply aggregate function. Here the aggregation in select has no sense.
By the way it should be the same or more quickly to select records into internal table and collect. Or maybe the group addition in select will do the same.
KR.
Zdeno
| | | ---------------Original Message---------------
From: randysy
Sent: Thursday, May 05, 2011 2:27 AM
Subject: Aggregate functions in cluster tables
Hi,
I am trying to do the below query;
SELECT SUM ( field ) FROM cluster_table INTO variable FROM cluster_table.
There is an error about using aggregate functions on cluster tables.Why is this so?
How can I resolve this? Inputs would be very useful. Thanks!
~randysy~ |
| __.____._ Copyright © 2011 Toolbox.com and message author.
Toolbox.com 4343 N. Scottsdale Road Suite 280, Scottsdale, AZ 85251
| |  Zdeno
SAP Development Enthusiast
Contributed 100 posts in a group to earn a Bronze Achievement Popular White Papers
In the Spotlight  _.____.__ |
