Informix Error -9408

Cause and resolution

User-defined aggregate <aggregate-name> has no arguments. </aggregate-name>

The user-defined aggregate in your SELECT statement does not specify any arguments

Make sure that the user-defined aggregate of the SELECT statement provides the correct number of arguments (one or possibly two, if the aggregate includes a set-up argument).

Oninit® Troubleshooting Guidance

Reasons / Common Causes

-9408 fires when a user-defined aggregate is called in a SELECT statement without any arguments — per the official guidance.

A call to the aggregate with zero arguments, per the official guidance — the direct, only cause.

Solutions / Resolution

Provide the correct number of arguments (one, or two if the aggregate includes a set-up argument), per the official guidance.

Examples

Calling an aggregate with no arguments

SELECT new_aggr() FROM some_table;   -- -9408

Corrected

SELECT new_aggr(colA) FROM some_table;

Diagnostic Checks

Check the aggregate's CREATE AGGREGATE definition for whether it expects one or two arguments, and supply the correct count in the call.

Related Errors / Related Topics

-9409 — "User-defined aggregate has too many arguments." The inverse case — supplying more arguments than the aggregate expects.

The aggregate was called with no arguments — supply one (or two, if a set-up argument is defined).