KNOWLEDGE BASE

DB2 Error: "SQL0100W No Row Was Found for Fetch, Update or Delete"; or a Query Results as an Empty Table


Published: 10 Apr 2017
Last Modified Date: 11 Apr 2017

Issue

After connecting to a table from IBM DB2, then selecting the Update now button, the following error message might occur:

[IBM][CLI Driver][DB2] SQL0100W No row was found for FETCH, UPDATE or DELETE; or the result of a query is an empty table. SQLSTATE=02000.

Environment

  • Tableau Desktop
  • IBM DB2 z-Series (z/OS)
  • DB2 driver version 10.5

Resolution

Please use an older version of the driver until a new driver is released by IBM. For example, versions 10.1 and 9.7 are both known to work.

Cause

The version 10.5 DB2 driver has compatibility issues with z-Series DB2 mainframes.
Did this article resolve the issue?