Informix Error -9400

-9400 User-defined aggregate <aggregate-name> already exists. </aggregate-name>

The name given already exists in your database, either as an aggregate name or as the name of a routine. (You cannot have an aggregate and a routine with the same name.)

Change your CREATE AGGREGATE statement to give the aggregate a unique name.