title: DB2 - how to test if record exists before deleting
body: <p>spent time trying to figure out how to construct a DB2 SQL statement that first checks if record exists before deleting it. looking for somewhere along the lines:</p>
  
  <pre><code>if exists(select 1 from my_table where my_table.my_field = current date) then
     delete from my_table where my_table.my_field = current date
  </code></pre>
  
  <p>TIA!</p>