Informix Error -9642: A quoted string exceeds 32,768 bytes.
Cause and resolution
A quoted string exceeds 32,768 bytes.
The system imposes a limit of 32,768 bytes on quoted strings. You cannot exceed this limit.
Oninit® Troubleshooting Guidance
Reasons / Common Causes
-9642 fires when a quoted string literal exceeds the system's 32,768-byte limit — per the official guidance.
- A quoted string literal longer than 32,768 bytes, per the official guidance — the direct, only cause.
Solutions / Resolution
- Shorten the quoted string to within the 32,768-byte limit, per the official guidance's implication — the system imposes this limit and it can't be exceeded.
Examples
An oversized quoted string literal
INSERT INTO tab VALUES ('...(a string longer than 32768 bytes)...'); -- -9642
Diagnostic Checks
- Check the length of the quoted string literal, and shorten it, or use a host variable/parameter instead of an inline literal for large values.
Related Errors / Related Topics
No closely related error codes are cross-referenced for -9642 in this set yet.
A quoted string literal exceeded the 32,768-byte limit — shorten it or use a host variable instead.