Informix Error -32411: An Alter Table Option has already been altered.

Cause and resolution

An Alter Table Option has already been altered.

You attempted to perform an ALTER TABLE option on a table option that you previously altered. You cannot alter a table option more than once.

Oninit® Troubleshooting Guidance

Reasons / Common Causes

-32411 fires when ALTER TABLE attempts to change a table option that was already altered in the current session — per the official guidance.

A table option changed more than once in the same ALTER TABLE operation, per the official guidance — the direct, only cause; a table option can't be altered more than once.

Solutions / Resolution

Don't alter the same table option twice in one ALTER TABLE session, per the official guidance — complete and apply the first change, then start a new session for any further change.

Examples

N/A

No specific triggering statement is documented — this is a DB-Access interactive-menu restriction.

Diagnostic Checks

Confirm the table option hasn't already been changed earlier in the same session.

Related Errors / Related Topics

-32400 — "A Table_option has already been altered." The same one-change rule, worded generally for Table_option rather than a specific already-altered option.

A table option was altered more than once in the same ALTER TABLE session, which isn't permitted — start a new session for each change.