Restrictions on transaction management

Restrictions on transaction management are as follows:

  • Savepoints are not propagated to remote servers.
  • If nested BEGIN TRANSACTION and COMMIT TRANSACTION statements are included in a transaction that involves remote servers, only the outermost set of statements is processed. The innermost set, containing the BEGIN TRANSACTION and COMMIT TRANSACTION statements, is not transmitted to remote servers.
Copyright © 2008, iAnywhere Solutions, Inc. - SQL Anywhere 11.0.0