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