Informix Error -35226: This line uses an Informix extension to ISO/ANSI SQL, near identifier or symbol name.
Cause and resolution
This line uses an Informix extension to ISO/ANSI SQL, near identifier or symbol name.
Use of an Informix extension to ANSI has been detected. Use ANSI-compliant syntax to ensure maximum portability.
Oninit® Troubleshooting Guidance
Reasons / Common Causes
-35226 shares its exact message text with -35036 — per the official guidance, it fires when the
ESQL preprocessor, run with the -ansi option, detects an Informix-specific SQL extension that
ISO/ANSI standard SQL doesn't define.
- The
-ansicompile option being used, per the official guidance — this warning is suppressed entirely without it. - An Informix-specific extension appearing in the flagged statement, per the official guidance, near the named identifier or symbol.
Solutions / Resolution
- Use ANSI-compliant syntax to ensure maximum portability, per the official guidance.
- If ANSI compliance isn't actually a requirement, drop the
-ansioption instead of rewriting the statement.
Examples
N/A
No specific triggering statement is documented beyond "an Informix extension... near identifier or symbol name" — the exact offending syntax varies per statement.
Diagnostic Checks
- Confirm whether
-ansiis actually required for this build before investing in rewriting the flagged statement. - Identify the specific Informix extension in use at the named identifier/symbol.
Related Errors / Related Topics
- -35036 — Shares this exact message text and cause; the same ANSI-extension warning at a different code position in this set.
- -35038 — "This statement uses an Informix extension to the X/Open standard..." The X/Open-compliance-mode counterpart.
- -35227 — Shares -35038's message text; the X/Open counterpart to this code.
An Informix-specific SQL extension triggered this only because -ansi was in effect — use
ANSI-compliant syntax, or drop -ansi if ANSI portability isn't actually needed.