Informix Error -19830: This operation is not allowed on a table where the type is raw.

Cause and resolution

This operation is not allowed on a table where the type is raw.

An unsupported operation (for example, trying to create a constraint) was attempted on a RAW table.

You must alter the RAW table to a STANDARD table if you want to perform an operation that RAW tables do not support.

Oninit® Troubleshooting Guidance

Reasons / Common Causes

-19830 fires when an unsupported operation (e.g. creating a constraint) is attempted on a RAW table — per the official guidance.

An operation RAW tables don't support attempted on one, per the official guidance — the direct, only cause.

Solutions / Resolution

Alter the table from RAW to STANDARD, per the official guidance, if the unsupported operation is needed.

Examples

An unsupported operation on a RAW table

ALTER TABLE mytab ADD CONSTRAINT (col1 CHECK (col1 > 0));
-- -19830: mytab is RAW

Corrected

ALTER TABLE mytab TYPE (STANDARD);
ALTER TABLE mytab ADD CONSTRAINT (col1 CHECK (col1 > 0));

Diagnostic Checks

Check the table's type (RAW vs STANDARD), and alter it to STANDARD if the attempted operation requires it.

Related Errors / Related Topics

-19831 — "Referential constraints are not allowed on tables of type raw." The specific case of this restriction for referential constraints.
-19833 — "Table type raw not allowed together with access method." A related RAW- table restriction, about combining RAW with a user-defined access method.

An operation unsupported on RAW tables was attempted — alter the table to STANDARD if needed.