Informix Error -2039: The attributes AUTONEXT, DEFAULT, INCLUDE, VERIFY, RIGHT and ZEROFILL are not supported for BLOB fields.

Cause and resolution

The attributes AUTONEXT, DEFAULT, INCLUDE, VERIFY, RIGHT and ZEROFILL are not supported for BLOB fields.

Columns of BYTE and TEXT types cannot be used in the ways that these attributes imply. Check that the table and column names are as you intended, and verify the current definition of the table in the database that the DATABASE statement names.

Oninit® Troubleshooting Guidance

Reasons / Common Causes

-2039 fires when one of six specific attributes — AUTONEXT, DEFAULT, INCLUDE, VERIFY, RIGHT, or ZEROFILL — is applied to a BYTE/TEXT (BLOB) field — per the official guidance, these attributes simply aren't supported for that type.

One of the six named attributes applied to a BYTE/TEXT field, per the official guidance — the direct, only cause.

Solutions / Resolution

Verify that your table and column names are correct, per the official guidance, and confirm the current table definition — remove the unsupported attribute from the BYTE/ TEXT field.

Examples

An unsupported attribute on a BLOB field

ATTRIBUTES
  notes = order_notes, DEFAULT = "none";
-- -2039: DEFAULT isn't supported for TEXT fields

Corrected

ATTRIBUTES
  notes = order_notes;

Diagnostic Checks

Check every BYTE/TEXT field's attributes against the six unsupported ones (AUTONEXT, DEFAULT, INCLUDE, VERIFY, RIGHT, ZEROFILL), and remove any that appear.

Related Errors / Related Topics

-2037 — "The PROGRAM attribute can only be specified for BYTE and TEXT fields." A related BLOB-attribute restriction, about a different attribute (PROGRAM) that's only valid for these types, the mirror image of this error.
-2038 — "BLOB fields cannot be joined." A related BLOB restriction, about join usage rather than field attributes.

A BYTE/TEXT field has one of six unsupported attributes — remove it.