Oninit
Talk to an expert →

Informix Error -33058: Option-name is not a valid default option for the column definition.

Cause and resolution

Option-name is not a valid default option for the column definition.

See the IBM Informix Guide to SQL: Syntax for the valid DEFAULT clause options in a column definition.

Oninit® Troubleshooting Guidance

Reasons / Common Causes

-33058 fires when a column definition's DEFAULT clause uses an unsupported option — per the official guidance.

  1. A DEFAULT clause option not valid for a column definition, per the official guidance — the direct, only cause.
Solutions / Resolution
  1. Check the IBM Informix Guide to SQL: Syntax for valid DEFAULT clause options, per the official guidance, and correct the statement.
Examples
N/A

No specific triggering statement is documented beyond an invalid DEFAULT option.

Diagnostic Checks
  1. Check the flagged DEFAULT clause's option against the SQL Syntax guide's documented valid options.
Related Errors / Related Topics

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

A column definition's DEFAULT clause used an unsupported option — check it against the SQL Syntax guide.