IBM DB2에서 select and update,delete 하기

update 
(select * from pmegatest1
where c1=2 and c2='pmega'
fetch first 1 rows only)
set c1=11
with UR

delete from 
(select * from pmegatest1
where c1=2 and c2='pmega'
fetch first 1 rows only)
with UR

[출처] IBM DB2에서 select and update,delete 하기 (큰틀) |작성자 가이사


  DELETE FROM 
  (SELECT * FROM ${LIST_TABLE}
  WHERE POST_ID = '${POST_ID}'
  FETCH FIRST ${COMMIT_CNT} ROWS ONLY)
  WITH UR