Can anybody tell me how can I user savepoint and rollback to savepoint in unix shell script.
db2 -c- connect to <yuordatabase> user <yourlogin> using <password>
db2 -c- savepoint point1 on rollback retain cursors
db2 -c- create table x (id int)
db2 -c- rollback to savepoint point1