Informix Error -32124: Cannot modify an index on a temporary table.

Reasons / Common Causes

-32124 fires when a statement attempts to alter an index on a temporary table — per the official guidance.

1. The target index belongs to a temporary table, per the official guidance — the direct, only cause; altering indexes on temporary tables isn't legal.

Solutions / Resolution

1. Don't attempt to alter an index on a temporary table, per the official guidance — drop and recreate the temporary table with the desired index instead.

Examples

N/A

No specific triggering statement is documented beyond attempting to alter an index on a temporary table.

Diagnostic Checks

1. Confirm whether the target table is temporary, and recreate it with the desired index instead of altering an existing one.

Related Errors / Related Topics

No closely related error codes are cross-referenced for -32124 in this set yet.

A statement attempted to alter an index on a temporary table, which isn't legal — drop and recreate the table instead.