Informix Error -2985

-2985 The table identifiers name1 and name2 represent the same table.

In the TABLES section, these two names are defined in such a way that they refer to the same database table. One or both of them is a table alias. Change the statements so that each name stands for just one table and each table has just one name.

Oninit® Troubleshooting Guidance

Reasons / Common Causes

-2985 fires when two different identifiers in the TABLES section both resolve to the same underlying database table — per the official guidance, one or both of them is a table alias.

Two distinct TABLES identifiers resolving to the same underlying table, per the official guidance — the direct, only cause.

Solutions / Resolution

Change the statements so that each name stands for just one table and each table has just one name, per the official guidance.

Examples

Two aliases for the same table

TABLES
  o = orders
  ord = orders
-- -2985: "o" and "ord" both alias the orders table

Corrected

TABLES
  o = orders

Diagnostic Checks

Check every table identifier in TABLES, resolving aliases back to their real table names, and remove any redundant duplicate identifier.

Related Errors / Related Topics

-2984 — "The table identifier table is defined more than once." A related TABLES-section duplication error, about the same identifier appearing twice, rather than two different identifiers referring to the same table.

Two different TABLES identifiers both refer to the same underlying table — keep only one name per table.