There are quite a lot of subtly differences:CONNECT RESET and DISCONNECT are SQL statements, TERMINATE is a DB2 command.From the manuals:CONNECT RESET:==============On type 1 connections, it disconnects and runs a COMMIT before.http://publib.boulder....
显示全部There are quite a lot of subtly differences:
CONNECT RESET and DISCONNECT are SQL statements, TERMINATE is a DB2 command.
From the manuals:
CONNECT RESET:
==============
On type 1 connections, it disconnects and runs a COMMIT before.
http://publib.boulder.ibm.com/infoc...in/r0000906.htmOn type 2 connections, it connects to the default database. But there are a
few more options to control what happens.
http://publib.boulder.ibm.com/infoc...in/r0000908.htmDISCONNECT:
===========
Can only be used from an application and not interactively. Also, there
must not be an UOW running at the time of DISCONNECT.
http://publib.boulder.ibm.com/infoc...in/r0000943.htmTERMINATE:
==========
Explicitly terminates the command line processor's back-end process.
http://publib.boulder.ibm.com/infoc...re/r0001973.htmThrough that, it also disconnects from the DB2 server.
收起