The following table lists each transaction management statement and describes how it works when you use the PowerBuilder OLE DB 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, by default PowerBuilder automatically starts a transaction. Set SQLCA.AutoCommit=TRUE to tell PowerBuilder not to start a transaction automatically. |
|
DISCONNECT |
Terminates a successful connection. When a DISCONNECT is executed, PowerBuilder internally executes a COMMIT WORK statement to commit all changes and then issues a CLOSE DATABASE statement to terminate the logical unit of work. |
|
COMMIT |
Applies all changes made to the database since the beginning of the current unit of work. |
|
ROLLBACK |
Undoes all changes made to the database since the beginning of the current logical unit of work. |
See also
