Informix Error -9406

-9406 Cannot resolve support function for user-defined aggregate

You attempted to use a built-in aggregate for which the database server could not find an appropriate support function. For example, if you try to use the SUM aggregate on the "new_type" data type, the database server looks for the following operator function:

plus(new_type, new_type)

This error can also occur for a user-defined aggregate when one of the support functions that the CREATE AGGREGATE statement has listed (INIT/ITER/COMBINE/FINAL) is missing.

Make sure that you have the correct support functions for the user-defined aggregate. These functions must be exist and must be registered in the database with CREATE FUNCTION.