Informix Error -22231: Record nesting limit exceeded.

Cause and resolution

Record nesting limit exceeded.

The maximum number of levels for valid record nesting is 100. Reduce the number of nested records and try again.

Oninit® Troubleshooting Guidance

Reasons / Common Causes

-22231 fires when a record's nesting depth exceeds the maximum ESQL/COBOL supports — per the official guidance, the maximum is 100 levels.

A record nested more than 100 levels deep, per the official guidance — the direct, only cause.

Solutions / Resolution

Reduce the number of nested records and try again, per the official guidance.

Examples

N/A

No specific triggering statement is documented beyond exceeding 100 levels of nesting.

Diagnostic Checks

Count the record's nesting depth, and restructure it to stay within 100 levels.

Related Errors / Related Topics

-22210 — "Repeated data item variable-name is not expanded." A related record- structure error, on repeated data items rather than excessive nesting depth.

A record's nesting depth exceeded the 100-level maximum — reduce nested records.