title: SQLState 02000 No row was found for FETCH, UPDATE, or DELETE
body: <p>I'm running jobs through Datastage with the DELETE then INSERT connector.  I'm having several jobs failing for this error:</p>
  
  <pre><code>DB2_Connector:  DB2 reported:  SQLSTATE = 02000 Native Error Code = 100, Msg = IBM[CLIDriver][DB2/NT64] SQL01000W No row was found for FETCH, UPDATE, or DELETE
  </code></pre>
  
  <p>When I run the delete statement in Data Studio directly in DB2, it gives this same error so I know it's a DB2 error, not a Datastage error.</p>
  
  <p>Is there anyway to supress the message in Datastage or when I run the statement in DB2 is there anyway I can keep that message from coming up?  It's stopping my DS jobs now with a Fatal error and not continuing to load.</p>
  
  <p>There has got to be a way to turn off the message.  I know in SQL Server if no rows are found it does not give this error, it just says zero or doesn't return records but in DB2 this error is coming up and I'm not sure if there is a way to turn it off.</p>