Informix Error -19833: Table type raw not allowed together with access method.

Cause and resolution

Table type raw not allowed together with access method.

You cannot associate a user-defined primary access method with a raw (nonlogging) table.

If you want to associate a user-defined primary access method with your table, omit the keyword RAW from the CREATE TABLE statement. If you want a raw table, omit the USING <access_method> clause from the CREATE TABLE statement. </access_method>

Oninit® Troubleshooting Guidance

Reasons / Common Causes

-19833 fires when CREATE TABLE combines RAW with a USING <access_method> clause — per the official guidance. A user-defined primary access method can't be associated with a RAW (nonlogging) table.

RAW combined with USING <access_method>, per the official guidance — the direct, only cause.

Solutions / Resolution

Omit RAW if a user-defined primary access method is needed, per the official guidance.
Omit the USING <access_method> clause if a RAW table is needed, per the official guidance.

Examples

RAW combined with a primary access method

CREATE TABLE mytab (id INT) RAW USING myaccessmethod;

Corrected — keeping the access method

CREATE TABLE mytab (id INT) USING myaccessmethod;

Diagnostic Checks

Check the CREATE TABLE statement for both RAW and USING <access_method>, and decide which one to keep.

Related Errors / Related Topics

-19830 — "This operation is not allowed on a table where the type is raw." The general RAW-table restriction this is a specific case of, for access methods.

RAW can't be combined with a USING <access_method> clause — choose one.