Tuesday, June 8, 2010

DB2 CLP, How to turn autocommit off

By default DB2 uses autocommit, but you can disable it executing the "update command options".

Disable autocommit
update command options using c off
.
.
commit

Enable autocommit
update command options using c on

If executed from command line put all statements in a file and execute with:
db2 -tv +c -f filename

No comments:

Post a Comment