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 Develop ABL Applications for details on how ABL handles transactions and error conditions.