select - SQL / DB2 - retrieve value and update/increment simultaniously - Stack Overflow

I'm connecting to a DB2 database and executing SQL statements. One example of what is being done is: select field from library/file [program code line finishes executing] [increment value by ... ... update library/file set field = field + 1; select field

stackoverflow.com