Informix Error -2863: The column column-name does not exist among the specified tables.

Cause and resolution

The column column-name does not exist among the specified tables.

The tables that are specified in the TABLES section of the form exist, but column-name, which is named in the ATTRIBUTES section, does not. Check its spelling against the actual table. Possibly the table was altered, or the column was renamed. You can use Informix SQL to check column names under the Tables menu, Info selection.

Oninit® Troubleshooting Guidance

Reasons / Common Causes

-2863 fires when a column named in ATTRIBUTES doesn't exist in any of the tables listed in TABLES — per the official guidance, this typically happens from a spelling error, a table alteration, or a column rename.

A spelling error in the column name, per the official guidance — the first named cause.
A table alteration or column rename since the form was written, per the official guidance — the second named cause.

Solutions / Resolution

Check the column's spelling against the actual table, per the official guidance.
Use Informix SQL to check column names under the Tables menu, Info selection, per the official guidance.

Examples

Checking a table's actual columns

SELECT colname FROM syscolumns c, systables t
  WHERE c.tabid = t.tabid AND t.tabname = 'orders';

Diagnostic Checks

Check the referenced column's spelling against the tables listed in TABLES, via Informix SQL's Tables menu or a direct syscolumns query.

Related Errors / Related Topics

-2865 — "The column column-name does not exist in the table table-name." A related, more specific error, about a column missing from one particular named table, rather than from any of the tables listed in TABLES.

The referenced column doesn't exist in any of the tables listed in TABLES — verify its spelling via the Tables menu or syscolumns.