Informix Error -26294: API error: Missing open parenthesis.
Cause and resolution
API error: Missing open parenthesis.
The SELECT clause in the current EXTRACT statement is missing an open parenthesis. Correct and rerun the EXTRACT statement.
Oninit® Troubleshooting Guidance
Reasons / Common Causes
-26294 fires when an EXTRACT statement's SELECT clause has an unmatched close
parenthesis — per the official guidance.
- The
SELECTclause is missing a matching open parenthesis, per the official guidance — the direct, only cause.
Solutions / Resolution
- Add the missing open parenthesis and rerun the
EXTRACTstatement, per the official guidance.
Examples
N/A
No specific triggering statement is documented beyond a missing open parenthesis.
Diagnostic Checks
- Check the
SELECTclause's parentheses for balance, and add the missing open parenthesis.
Related Errors / Related Topics
- -26292 — "API error: Missing close parenthesis." The mirror-image error, on a missing close parenthesis rather than a missing open parenthesis.
An EXTRACT statement's SELECT clause was missing an open parenthesis — add it and
rerun.