Informix Error -26507: Query contains a table which is not a real table
Cause and resolution
Query contains a table which is not a real table
This query was not accelerated, because it contains a table which is not a real table (e.g. view, external table, sequence, synonym).
Oninit® Troubleshooting Guidance
Reasons / Common Causes
-26507 fires when a query isn't accelerated because it references a non-real table (e.g. a view, external table, sequence, or synonym) — per the official guidance.
- The query contains a view, external table, sequence, or synonym, 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 non-real table.
Diagnostic Checks
- This is an informational offload-diagnostic, not an error to fix.
Related Errors / Related Topics
- -26505 — "Query contains a pseudo table" A more specific instance of this general restriction.
- -26506 — "Query contains a temporary table" A more specific instance of this general restriction.
- -26508 — "Query contains a system catalog table" A more specific instance of this general restriction.
A query wasn't accelerated because it references a non-real table (view, external table, sequence, or synonym) — such queries run on the database server instead.