implicit commit ?

[d***@gmail.com]

hi all Guru, i have some question about implicit commit function on DB2 UDB v81 on windows.

Whenever i insert a rows into table, it will implicit commit. Cause i can see the result immediately on the other session without even typing commit on first session. Doesn't that only the statement is committed then only i can see the committed value on other session ?


please advice.

thanks.

[Steve Pearson]

Check out the "c" switch among CLP (command line processor invoked as "db2")
options here:
http://publib.boulder.ibm.com/infocenter/db2luw/v8/index.jsp?topic=/com.ibm.db2.udb.doc/core/r0010410.htm

Note that "+c" turns off auto-commit.

Regards,
- Steve P.
--
Steve Pearson, DB2 for Linux, UNIX, and Windows, IBM Software Group
"Portland" Development Team, IBM Beaverton Lab, Beaverton, OR, USA

[d***@gmail.com]

Hi, thanks for the info :) it work now.