Informix Error -26506: Query contains a temporary table
Cause and resolution
Query contains a temporary table
This query was not accelerated, because it contains a temporary table.
Oninit® Troubleshooting Guidance
Reasons / Common Causes
-26506 fires when a query isn't accelerated because it references a temporary table — per the official guidance.
- The query contains a temporary table, per the official guidance — the direct, only cause; not eligible for offloading.
Solutions / Resolution
- No action needed to "fix" this — per the official guidance, such a query runs on the database server instead.
Examples
N/A
No specific triggering statement is documented beyond a query referencing a temporary table.
Diagnostic Checks
- This is an informational offload-diagnostic, not an error to fix.
Related Errors / Related Topics
- -26505 — "Query contains a pseudo table" The same class of offload-ineligibility diagnostic, for pseudo tables rather than temporary tables.
- -26507 — "Query contains a table which is not a real table" The same class of offload-ineligibility diagnostic, for non-real tables generally.
- -26508 — "Query contains a system catalog table" The same class of offload- ineligibility diagnostic, for system catalog tables rather than temporary tables.
A query wasn't accelerated because it references a temporary table — such queries run on the database server instead.