Oninit
Talk to an expert →

Informix Error -824

Cause and resolution

Missing values clause on insert statement.

Probably no current IBM Informix product returns this message. If this message does appear, refer to the discussion of error -836. If the error recurs, note all circumstances and contact IBM Informix Technical Support.

Oninit® Troubleshooting Guidance

Reasons / Common Causes

-824 is documented as obsolete — per the official guidance, probably no current IBM Informix product returns this message. It's documented here for archival reference: on the platforms where it applied, it fired when an INSERT statement was missing its VALUES clause.

  1. An INSERT statement written without a VALUES clause (or a SELECT to supply rows), on the older platforms where this specific error applied.
Solutions / Resolution
  1. See the discussion of error -836, per the official guidance's own pointer, for the current documented behavior/message covering this same underlying condition on supported server versions.
  2. If this recurs on a current server version, note all circumstances and contact IBM Informix Technical Support, per the official guidance — its own text notes this shouldn't happen on current products.
Examples
The underlying condition, on affected older platforms
INSERT INTO orders (order_id, status);
-- missing VALUES (...) or a SELECT to supply the row(s)
Diagnostic Checks
  1. On a current server version, check error -836's discussion instead, per the official guidance's pointer, since that's the currently documented form of this condition.
Related Errors / Related Topics

No closely related error codes are cross-referenced for -824 in this set yet.

Obsolete — the official guidance's own text points to -836 for the current documented form of this condition.