Oninit
Talk to an expert →

Informix Error -6026: The named column must be indexed or sequential search must be selected.

Cause and resolution

The named column must be indexed or sequential search must be selected.

This call to dbselfield() names a column that does not have an index in the database, but the flag passed was ACCKEYED. Check that the correct column was named and that the correct database and table have been opened. If that is the case, then the index has been dropped and should be re-created before you run the program again.

Oninit® Troubleshooting Guidance

Reasons / Common Causes

-6026 fires when dbselfield() names a column with no index while the ACCKEYED flag is passed — per the archived catalogue, this may also mean the index was dropped and needs re-creating.

  1. An ACCKEYED request against a column with no index, per the archived catalogue.
  2. The index having been dropped since the program was written, per the archived catalogue.
Solutions / Resolution
  1. Confirm the correct column, database, and table were named.
  2. If the index was dropped, re-create it before running the program again, per the archived catalogue.
Examples
N/A

No specific triggering statement is documented beyond the function-level condition described above.

Diagnostic Checks
  1. Check whether the named column actually has an index in the current database.
Related Errors / Related Topics
  • -6043 — "Column is not a composite key."
  • -6052 — "Not all of the composite index is contained in the current view of this table."

An ACCKEYED request against an unindexed column — confirm the column/database, or re-create a dropped index.