Informix Error -11089: Invalid cursor position.
Cause and resolution
Invalid cursor position.
This Informix CLI error code is the same as SQLSTATE value S1109. The following functions can return this error code: SQLExecute(), SQLExecDirect(), SQLGetData(), and SQLGetStmtOption().
The cursor is on a row that was deleted or that has an error. Do not try to perform an action on a row that was deleted or that has an error.
Oninit® Troubleshooting Guidance
Reasons / Common Causes
-11089 fires when a function acts on a cursor positioned on a deleted or errored row — per
the official guidance, this is the same as SQLSTATE value S1109, returnable by
SQLExecute(), SQLExecDirect(), SQLGetData(), and SQLGetStmtOption().
- The cursor positioned on a row that was deleted, or that has an error, per the official guidance — the direct, only cause.
Solutions / Resolution
- Don't perform the action on a row that was deleted or has an error, per the official guidance.
Examples
N/A
No specific triggering statement is documented beyond acting on a deleted/errored row.
Diagnostic Checks
- Check the row's status before acting on it (e.g. via
rgfRowStatusfrom a priorSQLExtendedFetch()), and skip rows that are deleted or errored.
Related Errors / Related Topics
No closely related error codes are cross-referenced for -11089 in this set yet.
The cursor was positioned on a deleted or errored row — skip that row rather than acting on it.