Informix Error -8107: A user variable or parameter has been defined by the user more than once.

Cause and resolution

A user variable or parameter has been defined by the user more than once.

You can define a name only once in a DEFINE section. You used a name more than once in the ASCII, PARAM, or VARIABLE statements.

Oninit® Troubleshooting Guidance

Reasons / Common Causes

-8107 fires when a name is defined more than once in the DEFINE section — per the official guidance, across ASCII, PARAM, or VARIABLE statements.

The same name used more than once across ASCII/PARAM/VARIABLE statements, per the official guidance — the direct, only cause.

Solutions / Resolution

Rename one of the duplicate definitions.

Examples

A name reused across VARIABLE and PARAM

DEFINE
  PARAM total DECIMAL
  VARIABLE
    total DECIMAL
    -- -8107: "total" already defined as a PARAM

Diagnostic Checks

Check the DEFINE section for names reused across ASCII, PARAM, and VARIABLE statements, and rename to make them unique.

Related Errors / Related Topics

-8058 — "The ASCII field field-name has already been defined." A related duplicate-name restriction, specific to ASCII fields rather than variables/parameters generally.

A name is defined more than once across ASCII/PARAM/VARIABLE statements — rename one.