title: DB2 delete statement error when row not present
body: <p>Folks,
  In DB2 9.x, delete statement works normally and gives successful return code if the particular row is present. But if the row is not present, it returns non-zero</p>
  
  <p>ie  Say EmployeeTable  doesn't contain employeeID 1234
  <code>db2 "delete from EmployeeTable where employeeID = 1234"</code><br>
   It gives output as below.</p>
  
  <pre><code>SQL0100W  No row was found for FETCH, UPDATE or DELETE; or the result of a query is an empty table.  SQLSTATE=02000
  </code></pre>
  
  <p>Is there anyway to return a success/zero return code, if there are no rows present?</p>