Oninit
Talk to an expert →

Informix Error -6010: Value cannot be found.

Cause and resolution

Value cannot be found.

This call to dbfind() for a keyed search returned no data. The value that was requested was not found in the selected index column.

Oninit® Troubleshooting Guidance

Reasons / Common Causes

-6010 fires when a dbfind() keyed search finds no matching row — per the archived catalogue, the requested value simply isn't present in the selected index column.

  1. The requested key value not present in the index, per the archived catalogue — the direct, only cause.
Solutions / Resolution
  1. Treat this as a normal "not found" result, per the archived catalogue, rather than an error.
Examples
N/A

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

Diagnostic Checks
  1. Confirm the searched value and index column are the ones actually intended.
Related Errors / Related Topics
  • -6009 — "There is no data in the table."
  • -6035 — "No current row."

A keyed dbfind() search found no matching row — a normal "not found" outcome, not an error.