The following table lists each transaction management statement and describes how it works when you use the SAP Adaptive Server Enterprise interface to connect to a database:
|
Statement |
Description |
|---|---|
|
CONNECT |
Establishes the database connection. After you assign values to the required properties of the transaction object, you can execute a CONNECT. After the CONNECT completes successfully, PowerBuilder automatically starts a transaction. This is the start of a logical unit of work. If AutoCommit is true, PowerBuilder does not start a transaction. |
|
COMMIT |
COMMIT terminates the logical unit of work, guarantees that all changes made to the database since the beginning of the current unit of work become permanent, and starts a new logical unit of work. If AutoCommit is false (the default), a COMMIT TRANSACTION executes, then a BEGIN TRANSACTION executes to start a new logical unit of work. If AutoCommit is true, the COMMIT is issued but has no effect because all previous database changes were already automatically committed. |
|
DISCONNECT |
Terminates a successful connection. DISCONNECT automatically executes a COMMIT to guarantee that all changes made to the database since the beginning of the current unit of work are committed. If AutoCommit is false, a COMMIT TRANSACTION executes automatically to guarantee that all changes made to the database since the beginning of the current logical unit of work are committed. |
|
ROLLBACK |
ROLLBACK terminates a logical unit of work, undoes all changes made to the database since the beginning of the logical unit of work, and starts a new logical unit of work. If AutoCommit is false, a ROLLBACK TRANSACTION executes, then a BEGIN TRANSACTION executes to start a new logical unit of work. If AutoCommit is true, a ROLLBACK TRAN executes but has no effect because all previous database changes were already committed. |
See also
