title: DB2 Increment a value by a certain amount
body: <p>I need to write a query that increments a value in a table by 3 when run.</p>
  
  <p>I would like to do something like this but this doesn't work.</p>
  
  <p><code>UPDATE table
  SET value = (SELECT value
               FROM table
               WHERE condition = true) + 3</code>
  WHERE condition = true</p>
  
  <p>As in the title this is a DB2 database, any ideas?</p>
  
  <p><strong>EDIT:</strong> Actually this does work, could also do the + 3 in the select. I just had some stuff in the wrong place with the casting I had to do
  Thanks in advance</p>