Goal: I am trying to retrieve records that were affected by UPDATE
query.
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:
[42601][-199] [SQL0199] Keyword UPDATE not expected. Valid tokens: INSERT.