Informix Error -2864

-2864 The table table-name is not among the specified

tables.

The indicated table is used in this statement but is not defined in the TABLES section of the form specification. Check its spelling; if it is as you intended, add the table in the TABLES section.

Oninit® Troubleshooting Guidance

Reasons / Common Causes

-2864 fires when a statement uses a table that isn't declared in the form's TABLES section — per the official guidance, the table is referenced elsewhere in the form specification but was never added to TABLES.

A table used in the form specification but not declared in TABLES, per the official guidance — the direct, only cause.

Solutions / Resolution

Check the table name's spelling, per the official guidance.
If it's as intended, add the table to the TABLES section, per the official guidance.

Examples

A table used but not declared

TABLES
  orders

ATTRIBUTES
  cust_name = customer.name;
-- -2864: "customer" is referenced but not listed in TABLES

Corrected

TABLES
  orders, customer

ATTRIBUTES
  cust_name = customer.name;

Diagnostic Checks

Check every table prefix used in ATTRIBUTES (or elsewhere in the form) against the TABLES section, and add any that are missing.

Related Errors / Related Topics

-2862 — "The table table-name cannot be found in the database." A related table-reference error, about a table that doesn't exist in the database at all, rather than one that simply wasn't declared in TABLES.

A table is referenced in the form but not declared in TABLES — add it, or correct the spelling.