Informix Error -2984

-2984 The table identifier table is defined more than once.

Correct the statements in the TABLES section so that each table is defined just once. Possibly you have defined an alias that is the same as a real table name.

Oninit® Troubleshooting Guidance

Reasons / Common Causes

-2984 fires when the same table identifier is defined more than once in the TABLES section — per the official guidance, this can happen when an alias is defined that duplicates a real table name.

The same table identifier appearing twice in TABLES, per the official guidance — the direct, only cause.
An alias that duplicates an existing real table name, per the official guidance — one named way this occurs.

Solutions / Resolution

Correct the statements in TABLES so that each table is defined just once, per the official guidance.

Examples

A duplicate table identifier

TABLES
  orders
  orders
-- -2984: "orders" is defined twice

Corrected

TABLES
  orders

Diagnostic Checks

Check the TABLES section for the same identifier appearing more than once, including aliases that collide with real table names, and remove the duplicate.

Related Errors / Related Topics

-2985 — "The table identifiers name1 and name2 represent the same table." A related TABLES-section duplication error, about two different names both referring to the same underlying table, rather than one identifier defined twice.

The same table identifier is defined more than once in TABLES — remove the duplicate definition.