[db2inst1@suningtest ~]$ db2 "create table wp(id int)"DB20000I The SQL command completed successfully.[db2inst1@suningtest ~]$ db2 +c "insert into wp values(1)"DB20000I The SQL command completed successfully.[db2inst1@suningtest...
显示全部[db2inst1@suningtest ~]$ db2 "create table wp(id int)"
DB20000I The SQL command completed successfully.
[db2inst1@suningtest ~]$ db2 +c "insert into wp values(1)"
DB20000I The SQL command completed successfully.
[db2inst1@suningtest ~]$ db2 +c "savepoint savepoint1 on rollback retain cursors"
DB20000I The SQL command completed successfully.
[db2inst1@suningtest ~]$ db2 +c "insert into wp values(2)"
DB20000I The SQL command completed successfully.
[db2inst1@suningtest ~]$ db2 +c "select * from wp"
ID
-----------
1
2
2 record(s) selected.
[db2inst1@suningtest ~]$ db2 "rollback to savepoint savepoint1"
DB20000I The SQL command completed successfully.
[db2inst1@suningtest ~]$ db2 "select * from wp"
ID
-----------
1
1 record(s) selected.
[db2inst1@suningtest ~]$
savepoint是在一个事务里的,像你那样写,SAVEPOINT都是单独的无意义的事务了。你每次的插入默认已经提交了,这个事务已经结束了,所以你不能恢复到哪个SAVEPOINT
收起