Informix Error -26505: Query contains a pseudo table
Cause and resolution
Query contains a pseudo table
This query was not accelerated, because it contains a pseudo table.
Oninit® Troubleshooting Guidance
Reasons / Common Causes
-26505 fires when a query isn't accelerated because it references a pseudo table — per the official guidance.
- The query contains a pseudo 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 pseudo table.
Diagnostic Checks
- This is an informational offload-diagnostic, not an error to fix.
Related Errors / Related Topics
- -26506 — "Query contains a temporary table" The same class of offload-ineligibility diagnostic, for temporary tables rather than pseudo tables.
- -26507 — "Query contains a table which is not a real table" The same class of offload-ineligibility diagnostic, for non-real tables (views, external tables, sequences, synonyms) generally.
- -26508 — "Query contains a system catalog table" The same class of offload- ineligibility diagnostic, for system catalog tables rather than pseudo tables.
A query wasn't accelerated because it references a pseudo table — such queries run on the database server instead.