Informix Error -2834: NULL cannot be used as the default. It is already the default if you specify nothing.

Reasons / Common Causes

-2834 fires when an ATTRIBUTES statement's DEFAULT clause explicitly specifies NULL — per the official guidance, NULL is already the implicit default when no DEFAULT clause is present at all, making an explicit DEFAULT = NULL redundant and disallowed.

1. DEFAULT explicitly set to NULL, per the official guidance — the direct, only cause.

Solutions / Resolution

1. Remove the DEFAULT clause entirely, per the official guidance, since NULL is already the default with no clause at all.
2. Or specify an alternative, non-NULL default value, per the official guidance, if a genuine default is actually intended.

Examples

An explicit NULL default

ATTRIBUTES
  status = order_status, DEFAULT = NULL;
-- -2834: NULL is already the default; this is redundant and disallowed

Corrected — remove the clause

ATTRIBUTES
  status = order_status;

Diagnostic Checks

1. Check every DEFAULT clause for an explicit NULL value, and remove the clause (or supply a genuine non-NULL default) if found.

Related Errors / Related Topics

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

DEFAULT = NULL is redundant and disallowed — remove the clause, or supply a real default value.