Informix Error -22280: Line is too long.
Cause and resolution
Line is too long.
The SQL string in the EXEC SQL statement is too long to fit in the internal buffer. The maximum SQL string length should be less than 32,767.
Oninit® Troubleshooting Guidance
Reasons / Common Causes
-22280 fires when the SQL string in an EXEC SQL statement is too long to fit in the
internal buffer — per the official guidance, the maximum SQL string length must be less
than 32,767.
- An SQL string of 32,767 characters or more in an
EXEC SQLstatement, per the official guidance — the direct, only cause.
Solutions / Resolution
- Shorten the SQL string so it's below 32,767 characters, per the official guidance's implication.
Examples
N/A
No specific triggering statement is documented beyond an oversized EXEC SQL string.
Diagnostic Checks
- Check the length of the flagged
EXEC SQLstatement's SQL string, and shorten it below 32,767 characters.
Related Errors / Related Topics
No closely related error codes are cross-referenced for -22280 in this set yet.
An EXEC SQL statement's SQL string was too long for the internal buffer (max 32,766
characters) — shorten it.