Informix Error -26501: Subquery matching is not supported
Cause and resolution
Subquery matching is not supported
This subquery was not accelerated because accelerating a subquery is not supported yet.
Oninit® Troubleshooting Guidance
Reasons / Common Causes
-26501 fires when a subquery isn't accelerated because subquery acceleration isn't yet supported — per the official guidance.
- Accelerating a subquery isn't supported, per the official guidance — the direct, only cause; a platform limitation, not a fixable statement error.
Solutions / Resolution
- No action needed to "fix" this — per the official guidance, the query falls back to running on the database server instead (if fallback is enabled).
Examples
N/A
No specific triggering statement is documented beyond a subquery that can't be accelerated.
Diagnostic Checks
- This is an informational offload-diagnostic, not an error to fix — check that
use_dwafallback is on if the query still needs to run.
Related Errors / Related Topics
No closely related error codes are cross-referenced for -26501 in this set yet.
A subquery couldn't be accelerated because subquery acceleration isn't supported — the query falls back to the database server if fallback is enabled.