IBM® Informix® 12.10

Create user-defined aggregates

A user-defined aggregate extends the database server by providing information that allows the database server to apply that aggregate to data in the database. To create a user-defined aggregate, write and register support functions that perform the aggregation and then implement the aggregate with the CREATE Aggregate statement.

The CREATE Aggregate statement provides the following information about the aggregate to the database server:

The name of the aggregate
The owner of the aggregate
The names of the functions that support the aggregate
Modifiers to the aggregate

For the syntax of the CREATE AGGREGATE statement, see the IBM Informix Guide to SQL: Syntax.

You cannot create a user-defined aggregate for any of the following data types:

Collection data types: LIST, MULTISET, or SET
Unnamed row types
Smart-large-object data types: CLOB or BLOB
Simple-large-object data types: TEXT or BYTE

Send feedback | Examples exchange | Troubleshooting

To find the PDF, see Publications for the IBM Informix 12.10 family of products.
For the release notes, documentation notes, and/or machine notes, see the Release Notes page.

Release date: March 2013