Try OpenEdge Now
skip to main content
DataServer for Microsoft SQL Server
Initial Programming Considerations : Transactions


With DataServer operations, a MS SQL Server data source handles its own transaction roll back and recovery operations. However, the OpenEdge transaction scoping rules apply: a transaction ends when the code exits the outermost block that performs an update. With the DataServer, ABL performs as follows:
*Sends a COMMIT to the data source, when a transaction that updates a MS SQL Server data source ends successfully.c
*Sends a ROLLBACK to the data source if you interrupt the transaction.
See OpenEdge Getting Started: ABL Essentials for details on how ABL handles transactions and error conditions.
* Transaction scoping and buffer management