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 SQL Server transaction. This is the start
of a logical unit of work.
|
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, a COMMIT TRANSACTION executes, then
a BEGIN TRANSACTION executes to start a new logical unit of work.
If AutoCommit is true, an error occurs when a COMMIT executes.
|
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, an error occurs when a ROLLBACK executes.
|
Thank you for watching.