Hi Art,
Can you tell us what section of the Reference Guide makes this claim?
The old Cloudscape engine offered syntax for creating user-defined
aggregates but that machinery does not work in Derby. There is a JIRA
for this feature: DERBY-672. You may be able to do what you need by
using Derby functions. If you search the codeline for
"getMedianTestScore", you will find an example of how to code an
aggregating function which compute a median value over a set of rows.
Hope this helps,
-Rick
Art Majtenyi wrote:
Reference manual says, "You can also create your own aggregates to
perform other set functions such as calculating the standard deviation."
Has anyone done this?...Is there any docs to help with this?...It's
not as easy as a scalar function.
Art Majtenyi, [EMAIL PROTECTED]
WebSphere Business Monitor Development
IBM Corporation, RTP, NC
O: 919/254-4443, M: 919/302-8827
