Informix Error -47102: You have exceeded the temporary buffer size.
Cause and resolution
You have exceeded the temporary buffer size.
The buffer in the SQL editor, which holds the check-constraint value and the literal default-constraint value, is full. If you are modifying the check constraint, a different editor might have a larger buffer.
Oninit® Troubleshooting Guidance
Reasons / Common Causes
-47102 fires in the interactive ALTER TABLE menu when the SQL editor's buffer for a
check-constraint or literal default-constraint value fills up — per the official guidance.
- The check/default-constraint value exceeding the SQL editor's buffer size, per the official guidance — the direct, only cause.
Solutions / Resolution
- If modifying a check constraint, use a different editor with a larger buffer, per the official guidance.
Examples
N/A
No specific triggering statement is documented beyond an oversized constraint-value buffer.
Diagnostic Checks
- Check the constraint value's length, and switch to a larger-buffer editor if modifying a check constraint.
Related Errors / Related Topics
No closely related error codes are cross-referenced for -47102 in this set yet.
The SQL editor's temporary buffer for a constraint value was exceeded — use a larger-buffer editor for check constraints.