Informix Error -6009: There is no data in the table.

Cause and resolution

There is no data in the table.

Either dbselfield() or dbfind() returns this message when they are called for an empty table. The message does not reflect an error in the program but a condition of the table.

Oninit® Troubleshooting Guidance

Reasons / Common Causes

-6009 fires when dbselfield() or dbfind() is called against an empty table — per the archived catalogue, this reflects the table's actual (empty) state, not a program error.

The table genuinely has no rows, per the archived catalogue — not a bug, a data condition.

Solutions / Resolution

Treat this as a normal "no data" condition rather than an error, per the archived catalogue — handle it in program logic the same way an empty result set would be handled.

Examples

N/A

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

Diagnostic Checks

Confirm whether the table is actually expected to be empty at this point.

Related Errors / Related Topics

-6010 — "Value cannot be found."
-6011 — "End of file."
-6012 — "Beginning of file."

Not an error — the table genuinely has no rows; handle it as a normal empty-table condition.