Informix Error -12040: Smart Large Objects: Invalid truncate value for size.
Cause and resolution
Smart Large Objects: Invalid truncate value for size.
The new size parameter supplied to a truncate operation for a smart large object was invalid. The new size parameter was probably less than zero. Correct the smart-large-object application program.
Oninit® Troubleshooting Guidance
Reasons / Common Causes
-12040 fires when a smart-large-object truncate operation's new-size parameter is invalid — per the official guidance.
- A new-size parameter probably less than zero, per the official guidance — the direct, only cause.
Solutions / Resolution
- Correct the smart-large-object application program's truncate size argument, per the official guidance.
Examples
N/A
No specific triggering statement is documented beyond a negative/invalid truncate size.
Diagnostic Checks
- Check the size argument passed to the truncate call, and confirm it's a valid, non-negative value.
Related Errors / Related Topics
- -12041 — "Smart Large Objects: Size of smart large object or buffer is too big." A related size-validity error, on exceeding the maximum size rather than being negative.
A smart-large-object truncate call's new-size parameter was invalid (likely negative) — correct the application's size argument.