transactions

nelapsi · #1 (**permalink**) 02-14-06, 04:03

how can i start transaction?
before DB2 I have using PostgresSQL and i just do

Code:

CREATE table t111(id integer);
START TRANSACTION ;
insert into t111 values(1);
insert into t111 values(2);
insert into t111 values(3);
select count(*) from t111;
 count
-------
     3
(1 row)

rollback;
select count(*) from t111;
 count
-------
     0
(1 row)

in db2 i do

Code:

CREATE table t111(id integer)
commit
insert into t111 values(1)
insert into t111 values(2)
insert into t111 values(3)
select count(*) from t111

1
-----------
          3
rollback
select count(*) from t111

1
-----------
          3

that I must to do to get real transaction?
PS sorry for my english

przytula · #2 (**permalink**) 02-14-06, 06:16

if executed from command line
put all statements in a file
execute with db2 -tv +c -f filename
or see db2 ? options or see Command line processor options in infocenter

grahammartin · #3 (**permalink**) 02-14-06, 06:25

There isn't an explicit TRANSACTION in DB2, but there is:

db2 "create table g1 (col1 int)"
db2 "insert into g1 values(1)"
db2 "commit"
db2 +c "insert into g1 values(2)"
db2 "rollback"

in the above scenario, onlt the value of 1 will be in the table

Within SQL/PL in DB2 Stored Procedures, you can make use
of the SAVEPOINT, COMMIT, ROLLBACK commands.

Graham Martin
http://www.ibm.com/software/data/db2/migration/

gardenman · #4 (**permalink**) 02-14-06, 07:03

By default db2 uses autocommit.
You can use "update command options" to disable autocommit.

--disable autocommit
update command options using c off
.
.
.
commit
-- enable autocommit
update command options using c on

nelapsi · #5 (**permalink**) 02-14-06, 07:47

Quote:

Originally Posted by gardenman

By default db2 uses autocommit.
You can use "update command options" to disable autocommit.

--disable autocommit
update command options using c off
.
.
.
commit
-- enable autocommit
update command options using c on

thnx..
but I'm using DB2 via ODBC..
How can I do smth like this via ODBC?
I want to use some statements with autocommit and another statements without it (with manual commit/rollback)

nelapsi · #6 (**permalink**) 02-15-06, 08:29

Quote:

Originally Posted by nelapsi

thnx..
but I'm using DB2 via ODBC..
How can I do smth like this via ODBC?
I want to use some statements with autocommit and another statements without it (with manual commit/rollback)

thnx to all..
I did it via odbc

Internet Services

Web Development

Digital Marketing

Consumer Tech