Informix Error -23858: This operation is not allowed on a temporary table (<tabname>). </tabname>
Cause and resolution
This operation is not allowed on a temporary table (<tabname>). </tabname>
The specified table is a temporary table, and the attempted operation is not allowed on a temporary table.
Specify a table that is not temporary and retry the operation.
Oninit® Troubleshooting Guidance
Reasons / Common Causes
-23858 fires when an operation not allowed on a temporary table is attempted — per the official guidance.
- An operation unsupported on temporary tables, per the official guidance — the direct, only cause.
Solutions / Resolution
- Specify a table that isn't temporary and retry the operation, per the official guidance.
Examples
N/A
No specific triggering statement is documented beyond an unsupported operation on a temporary table.
Diagnostic Checks
- Check whether the target table is temporary, and use a non-temporary table if the operation requires it.
Related Errors / Related Topics
- -23859 — "This operation is not allowed on a violations/diagnostics table
(
)." The same class of table-kind restriction, for violations/diagnostics tables rather than temporary tables. - -23860 — "This operation is not allowed on a duplicated table (
)." The same class of table-kind restriction, for duplicated tables rather than temporary tables.
The operation isn't allowed on a temporary table — use a non-temporary one.