Informix Error -11008: No rows updated or deleted.
Cause and resolution
No rows updated or deleted.
This Informix CLI error code is the same as SQLSTATE value 01S03. The following functions can return this error code: SQLExecDirect() and SQLExecute().
The function returned SQL_SUCCESS_WITH_INFO, which means that the function completed successfully, and that a nonfatal error occurred. The nonfatal error occurred because the SQL statement or prepared statement contained a positioned UPDATE or DELETE statement, but the function did not update or delete any rows. For more information, call SQLError().
Oninit® Troubleshooting Guidance
Reasons / Common Causes
-11008 fires when SQLExecDirect()/SQLExecute() runs a positioned UPDATE/DELETE that
affects no rows — per the official guidance, this is the same as SQLSTATE value 01S03.
- A positioned
UPDATE/DELETEstatement matching zero rows, per the official guidance — the direct, only cause.
Solutions / Resolution
- Confirm the cursor is positioned on the intended row, per the official guidance's implication, before issuing the positioned statement.
Examples
N/A
No specific triggering statement is documented beyond a positioned UPDATE/DELETE matching no rows.
Diagnostic Checks
- Check the cursor's current position before the positioned statement executes, and confirm the underlying row still exists.
Related Errors / Related Topics
- -11009 — "More than one row updated or deleted." The mirror-image condition — too many rows affected rather than none.
A positioned UPDATE/DELETE affected zero rows — confirm the cursor's position beforehand.