Mr. Fabio
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
Newer Post
Older Post
Home
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment