Question

如何用db2 delete 1万条 提交一次？

Answer 1

delete from (select * from tab_name fetched first 10000 rows only)

追问

我想每一万条提交一次，有什么命令吗？

追答

delete from (select * from tab_name where col < .... fetch first 10000 rows only);
commit;
写个过程，把上面的语句放在循环中执行。