aggregateName

An aggregateName represents a user-defined aggregate (UDA). To create a UDA, use the CREATE DERBY AGGREGATE statement.

Syntax

[ schemaName. ] SQLIdentifier

You can qualify an aggregate name with a schemaName. If a qualified aggregate name is specified, the schema name cannot begin with SYS.

Example

-- types.maxPrice is an aggregateName that includes a schemaName
CREATE DERBY AGGREGATE types.maxPrice FOR PRICE
EXTERNAL NAME 'com.example.myapp.types.PriceMaxer';