Informix Error -823

Reasons / Common Causes

-823 fires when the interactive tool's Run option is selected but no SQL statement has actually been entered — per the official guidance, the direct, only cause.

1. Run selected before typing any statement into the editor, per the official guidance — the direct, only cause.
2. A previous Choose/Save/Clear action left the editor empty, and Run was selected without noticing.

Solutions / Resolution

1. Enter a statement, per the official guidance, before selecting Run.
2. Or use Choose to load one, per the official guidance, if a previously saved statement was meant to be run instead of typed fresh.

Examples

Entering a statement before running

> SELECT * FROM orders;
> [Run]

Diagnostic Checks

1. Confirm the editor buffer actually contains a statement before selecting Run.

Related Errors / Related Topics

• -801 — "SQL Edit buffer is full." A related editor-state error, about too much content rather than none.
• -808 — "Cannot open file for choose." A related error, about loading a saved statement via Choose rather than the buffer being empty.

Enter a statement, or use Choose to load a previously saved one, before selecting Run.