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:
[-199] [SQL0199] Keyword UPDATE not expected. Valid tokens: INSERT.
Asked by Ruslan
(141 rep)
Mar 20, 2019, 09:22 PM
Last activity: Mar 20, 2019, 10:34 PM
Last activity: Mar 20, 2019, 10:34 PM