Informix Error -35227: This statement uses an Informix extension to the X/Open standard, near identifier or symbol name.

Reasons / Common Causes

-35227 shares its exact message text with -35038 — per the official guidance, it fires when the ESQL preprocessor, run with the -xopen option, detects an Informix-specific SQL extension that the X/Open standard doesn't define.

1. The -xopen compile option being used, per the official guidance — this warning is suppressed entirely without it.
2. An Informix-specific extension appearing in the flagged statement, per the official guidance, near the named identifier or symbol.

Solutions / Resolution

1. Use an X/Open-compliant syntax to ensure maximum portability, per the official guidance.
2. If X/Open compliance isn't actually a requirement, drop the -xopen option 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

1. Confirm whether -xopen is actually required for this build before investing in rewriting the flagged statement.
2. Identify the specific Informix extension in use at the named identifier/symbol.

Related Errors / Related Topics

• -35038 — Shares this exact message text and cause; the same X/Open-extension warning at a different code position in this set.
• -35036 — "This line uses an Informix extension to ISO/ANSI SQL..." The ANSI-compliance-mode counterpart.
• -35226 — Shares -35036's message text; the ANSI counterpart to this code.

An Informix-specific SQL extension triggered this only because -xopen was in effect — use X/Open-compliant syntax, or drop -xopen if X/Open portability isn't actually needed.