Informix Error -9402: Multiple occurrences of the <modifier-name> modifier. </modifier-name>

Cause and resolution

Multiple occurrences of the <modifier-name> modifier. </modifier-name>

Each of the modifiers INIT, ITER, COMBINE, FINAL, and HANDLESNULLS can appear only once in the CREATE AGGREGATE statement. Check your statement for repeated modifier names.

Oninit® Troubleshooting Guidance

Reasons / Common Causes

-9402 fires when a CREATE AGGREGATE statement repeats one of the INIT, ITER, COMBINE, FINAL, or HANDLESNULLS modifiers — per the official guidance.

A repeated modifier name in the CREATE AGGREGATE statement, per the official guidance — the direct, only cause; each of these modifiers may appear only once.

Solutions / Resolution

Check the statement for repeated modifier names, per the official guidance, and remove the duplicate.

Examples

A repeated ITER modifier

CREATE AGGREGATE new_aggr WITH (ITER = iter_func, ITER = iter_func2, ...);
-- -9402: ITER specified twice

Corrected

CREATE AGGREGATE new_aggr WITH (ITER = iter_func, ...);

Diagnostic Checks

Check the CREATE AGGREGATE statement for a modifier name (INIT/ITER/COMBINE/FINAL/ HANDLESNULLS) that appears more than once, and remove the duplicate.

Related Errors / Related Topics

-9403 — "The modifier must be specified." A related modifier-validity error, on a missing required modifier rather than a duplicated one.

A CREATE AGGREGATE modifier (INIT/ITER/COMBINE/FINAL/HANDLESNULLS) was specified more than once — remove the duplicate.