Informix Error -2831: The control block has exceeded the maximum of limit fields.
Cause and resolution
The control block has exceeded the maximum of limit fields.
Too many columns or tables are listed in the OF clause of this control block. Write separate control blocks, each for part of the list.
Oninit® Troubleshooting Guidance
Reasons / Common Causes
-2831 fires when a control block's OF clause lists more columns/tables than the documented
maximum — per the official guidance, this is a hard limit on how many fields one control block
can reference.
- Too many columns or tables listed in a control block's
OFclause, per the official guidance — the direct, only cause.
Solutions / Resolution
- Write separate control blocks, each for part of the list, per the official
guidance — split the oversized
OFclause across multiple control blocks.
Examples
N/A
No specific triggering statement is documented — split an oversized OF clause's field list
across multiple control blocks.
Diagnostic Checks
- Count the fields listed in the control block's
OFclause, and split it into multiple control blocks if it exceeds the documented limit.
Related Errors / Related Topics
No closely related error codes are cross-referenced for -2831 in this set yet.
A control block's OF clause exceeds the maximum field count — split it into separate control
blocks.