Informix Error -19832: Cannot alter table type in combination with other alter table options.

Cause and resolution

Cannot alter table type in combination with other alter table options.

You cannot alter the table type in combination with other ALTER TABLE options.

You must use separate statements to alter the table type with an ALTER TABLE statement. It cannot be done in combination with other ALTER TABLE options.

Oninit® Troubleshooting Guidance

Reasons / Common Causes

-19832 fires when ALTER TABLE ... TYPE is combined with other ALTER TABLE options in the same statement — per the official guidance.

TYPE combined with other ALTER TABLE clauses in one statement, per the official guidance — the direct, only cause.

Solutions / Resolution

Use a separate ALTER TABLE statement to change the table type, per the official guidance, apart from other alterations.

Examples

TYPE combined with another ALTER TABLE option

ALTER TABLE mytab TYPE (STANDARD) ADD col1 INT;

Corrected

ALTER TABLE mytab TYPE (STANDARD);
ALTER TABLE mytab ADD col1 INT;

Diagnostic Checks

Check ALTER TABLE statements for TYPE combined with other options, and split them into separate statements.

Related Errors / Related Topics

-19830 — "This operation is not allowed on a table where the type is raw." A related table-type error, about operations unsupported on RAW tables rather than combining TYPE with other options.

ALTER TABLE ... TYPE must be its own statement — split it from other ALTER TABLE options.