Goal: I am trying to retrieve records that were affected by
Based on IBMs article I can use the following query:
SELECT empno, salary FROM FINAL TABLE (UPDATE employee SET salary = salary * 1.10 WHERE job = 'CLERK')
However when I try to run similar query in database I get the following error:
[-199] [SQL0199] Keyword UPDATE not expected. Valid tokens: INSERT.