Informix Error -3265

-3265 A required index on column-name is missing. Restore.

All dominant columns (those with asterisks before their names) in verify joins must be indexed. Perhaps the index has been dropped since the form was compiled. Re-create the index, and run the form again.

Oninit® Troubleshooting Guidance

Reasons / Common Causes

-3265 fires at runtime when a dominant verify-join column has no index — per the official guidance, all dominant columns (marked *) in verify joins must be indexed, and this typically means the index was dropped since the form was compiled.

The index on a dominant (*-prefixed) verify-join column was dropped, per the official guidance — the direct, only cause.

Solutions / Resolution

Re-create the index, and run the form again, per the official guidance.

Examples

Re-creating the missing index

CREATE INDEX idx_customer_cust_id ON customer (cust_id);

Diagnostic Checks

Check whether the dominant column still has an index, and re-create it if it was dropped.

Related Errors / Related Topics

-2920 — "The column column is a dominant column but it is not indexed." A related compile-time warning covering this same requirement, surfaced before the form is ever run.
-3037 — "The column column-name is not a composite column. Build your form again." A related runtime missing-index error, about a dropped composite index rather than a dropped dominant-column index.

A dominant verify-join column's index was dropped since the form was compiled — re-create it and run the form again.