Informix Error -8058: The ASCII field field-name has already been defined.

Cause and resolution

The ASCII field field-name has already been defined.

A field name can be defined only once. Field names must be unique in the DEFINE section, that is, a name cannot be used for both a PARAM and a field.

Oninit® Troubleshooting Guidance

Reasons / Common Causes

-8058 fires when an ASCII field name is defined more than once — per the official guidance, field names must be unique in the DEFINE section, including not overlapping with PARAM names.

The same field name defined twice in the DEFINE section, per the official guidance — the first named case.
A name used for both a PARAM and a field, per the official guidance — the second named case.

Solutions / Resolution

Rename one of the duplicate field/param definitions.

Examples

A field name reused as a PARAM

DEFINE
  PARAM order_id LIKE orders.order_id
  ASCII
    order_id CHAR(10)
    -- -8058: order_id already used as a PARAM

Diagnostic Checks

Check the DEFINE section for duplicate names across ASCII fields and PARAMs, and rename to make them unique.

Related Errors / Related Topics

No closely related error codes are cross-referenced for -8058 in this set yet.

An ASCII field name collides with an existing field or PARAM — rename one of them.