Informix Error -11087: Row value out of range.
Cause and resolution
Row value out of range.
This Informix CLI error code is the same as SQLSTATE value S1107. The following function can return this error code: SQLExtendedFetch().
SQL_CURSOR_TYPE was SQL_CURSOR_KEYSET_DRIVEN but the SQL_KEYSET_SIZE value was greater than 0 and less than the SQL_ROWSET_SIZE value. Set SQL_KEYSET_SIZE to a value that is valid for the SQL_CURSOR_TYPE value.
Oninit® Troubleshooting Guidance
Reasons / Common Causes
-11087 fires when SQLExtendedFetch()'s keyset size is smaller than the rowset size for a
keyset-driven cursor — per the official guidance, this is the same as SQLSTATE value S1107.
SQL_CURSOR_TYPEwasSQL_CURSOR_KEYSET_DRIVEN, withSQL_KEYSET_SIZEgreater than 0 but less thanSQL_ROWSET_SIZE, per the official guidance — the direct, only cause.
Solutions / Resolution
- Set
SQL_KEYSET_SIZEto a value valid for the cursor'sSQL_CURSOR_TYPE, per the official guidance.
Examples
N/A
No specific triggering statement is documented beyond a keyset size smaller than the rowset size.
Diagnostic Checks
- Check
SQL_KEYSET_SIZErelative toSQL_ROWSET_SIZE, and confirm it's either 0 (fully keyset-driven) or at least as large as the rowset size.
Related Errors / Related Topics
- -11086 — "Fetch type out of range." A related
SQLExtendedFetch()argument-validity error, on the fetch type rather than the keyset/rowset size relationship.
A keyset-driven cursor's SQL_KEYSET_SIZE was smaller than its rowset size — set it to 0 or
at least the rowset size.