Oninit
Talk to an expert →

Informix Error -47087: Cannot specify null default value when column doesn't accept nulls.

Cause and resolution

Cannot specify null default value when column doesn't accept nulls.

Select a different (nonnull) default value for the column, or modify the column to accept null values.

Oninit® Troubleshooting Guidance

Reasons / Common Causes

-47087 fires in the interactive ALTER TABLE menu when a NULL default value is specified for a column that doesn't accept nulls — per the official guidance.

  1. NULL specified as a default for a NOT NULL column, per the official guidance — the direct, only cause.
Solutions / Resolution
  1. Select a different, non-null default value, per the official guidance.
  2. Or modify the column to accept null values, per the official guidance.
Examples
N/A

No specific triggering statement is documented beyond this menu-driven default-value restriction.

Diagnostic Checks
  1. Check whether the column is NOT NULL, and either choose a non-null default or allow nulls on the column.
Related Errors / Related Topics

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

NULL can't be a default value for a column that doesn't accept nulls — choose a non-null default or allow nulls.