Informix Error -2861

-2861 You have exceeded the maximum of number tables.

A limit exists on the number of tables that can be in use at one time. (This limit might be different on different host systems or with different database servers.) Reduce the number of tables that you use in the form.

Oninit® Troubleshooting Guidance

Reasons / Common Causes

-2861 fires when a form specification's TABLES section lists more tables than the compiler allows in use at once — per the official guidance, this limit can differ across host systems and database servers.

Too many tables listed in the TABLES section, exceeding the host/server-specific limit, per the official guidance — the direct, only cause.

Solutions / Resolution

Reduce the number of tables used in the form, per the official guidance.

Examples

Too many tables in a single form

TABLES
  orders, customer, item, warehouse, shipment, carrier, region, ...
-- -2861: this form references more tables than the compiler permits

Corrected

Split the form's data needs across fewer tables — for example, by pulling only the columns actually displayed, or by denormalizing a lookup value into the base table instead of joining to it.

Diagnostic Checks

Check the count of tables listed in TABLES, and reduce it — the exact limit is host/server-specific, so consult local Informix documentation for the number in effect.

Related Errors / Related Topics

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

Too many tables are listed in the form's TABLES section — reduce the count to fit the host/server-specific limit.