Only Dynamic Server supports this statement, which is an extension to the ANSI/ISO standard for SQL.
>>-DROP AGGREGATE--+-----------+--aggregate-------------------->< '- owner--.-'
| Element | Description | Restrictions | Syntax |
|---|---|---|---|
| aggregate | Name of the user-defined aggregate to be dropped | Must have been previously created with the CREATE AGGREGATE statement | Identifier |
| owner | Owner of the aggregate | Must own the aggregate | Owner Name |
Dropping a user-defined aggregate does not drop the support functions that you defined for the aggregate in the CREATE AGGREGATE statement. The database server does not track dependency of SQL statements on user-defined aggregates that you use in the statements. For example, you can drop a user-defined aggregate that is used in an SPL routine.
The following example drops the user-defined aggregate named my_avg:
DROP AGGREGATE my_avg
Related statements: CREATE AGGREGATE
For information about how to invoke a user-defined aggregate, see the discussion of user-defined aggregates in the Expression segment. For a description of the sysaggregates system catalog table that holds information about user-defined aggregates, see the IBM Informix Guide to SQL: Reference. For a discussion of user-defined aggregates, see IBM Informix User-Defined Routines and Data Types Developer's Guide.