Informix Error -26287: API error: ORDER BY field duplicated.
Cause and resolution
API error: ORDER BY field duplicated.
The host fields in the ORDER BY clause in the current EXTRACT statement are duplicated. Correct and rerun the EXTRACT statement.
Oninit® Troubleshooting Guidance
Reasons / Common Causes
-26287 fires when an EXTRACT statement's ORDER BY clause lists the same host field
more than once — per the official guidance.
- A host field duplicated in the
ORDER BYclause, per the official guidance — the direct, only cause.
Solutions / Resolution
- Correct the
EXTRACTstatement to remove the duplicateORDER BYfield and rerun, per the official guidance.
Examples
N/A
No specific triggering statement is documented beyond a duplicated ORDER BY field.
Diagnostic Checks
- Check the
ORDER BYclause for a repeated field, and remove the duplicate.
Related Errors / Related Topics
- -26288 — "API error: GROUP BY field duplicated." The same class of duplicate-field
error, for
GROUP BYrather thanORDER BY.
An EXTRACT statement's ORDER BY clause had a duplicated field — remove the duplicate
and rerun.