Informix Error -26304: API error: Bad ORDER BY clause.
Cause and resolution
API error: Bad ORDER BY clause.
The ORDER BY clause in the current EXTRACT statement is invalid. Correct and rerun the EXTRACT statement.
Oninit® Troubleshooting Guidance
Reasons / Common Causes
-26304 fires when an EXTRACT statement's ORDER BY clause is invalid — per the official
guidance.
- The
ORDER BYclause is invalid, per the official guidance — the direct, only cause.
Solutions / Resolution
- Correct the
ORDER BYclause and rerun theEXTRACTstatement, per the official guidance.
Examples
N/A
No specific triggering statement is documented beyond an invalid ORDER BY clause.
Diagnostic Checks
- Check the
ORDER BYclause's syntax, and correct it.
Related Errors / Related Topics
- -26287 — "API error: ORDER BY field duplicated." A related
ORDER BYerror, on a specific duplicate-field case rather than the clause being invalid generally. - -26303 — "API error: Bad GROUP BY clause." The same class of clause-validity error,
for
GROUP BYrather thanORDER BY.
An EXTRACT statement's ORDER BY clause was invalid — correct it and rerun.