Sample Header Ad - 728x90

DB2 select from final table update gives SQL0199 error

0 votes
1 answer
2047 views
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