savepoint in shell script

kumar_r · #1 (**permalink**) 10-13-05, 10:17

How can I use savepoint and rollback to savepoint in unix shell script?

Thanks,
Kumar

kumar_r · #2 (**permalink**) 10-13-05, 17:20

Can anybody tell me how can I user savepoint and rollback to savepoint in unix shell script.

thanks

gardenman · #3 (**permalink**) 10-14-05, 07:45

Quote:

Originally Posted by kumar_r

Can anybody tell me how can I user savepoint and rollback to savepoint in unix shell script.

thanks

[QUOTE]
#/bin/bash
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
[QUOTE]

Internet Services

Web Development

Digital Marketing

Consumer Tech