Connection Information

To perform the requested action, WordPress needs to access your web server. Please enter your FTP credentials to proceed. If you do not remember your credentials, you should contact your web host.

Connection Type

Microsoft SQL Server Using CONNECT, COMMIT, DISCONNECT, and ROLLBACK – PB Docs 126 – PowerBuilder Library

Microsoft SQL Server Using CONNECT, COMMIT, DISCONNECT, and ROLLBACK – PB Docs 126

Microsoft SQL Server Using CONNECT, COMMIT, DISCONNECT, and ROLLBACK

The following
table lists each transaction management statement and describes how
it works when you use the SQL Server 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 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.

See also


Document get from Powerbuilder help
Thank you for watching.
Was this article helpful?
Subscribe
Notify of
guest
0 Comments
Oldest
Newest Most Voted
Inline Feedbacks
View all comments
0
Would love your thoughts, please comment.x
()
x