Informix Error -824: Missing values clause on insert statement.

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.