Transaction Management and Remote Data

Transactions provide a way to group SQL statements so that they are treated as a unit—either all work performed by the statements is committed to the database, or none of it is.

Transaction management for remote tables is handled for the most part as it is in SQL Anywhere, although there are some differences.

See SQL Anywhere Server - SQL Usage > Using transactions and isolation levels.

For a general discussion of transactions, see Sybase IQ System Administration Guide: Volume 1 > Transactions and Versioning.

• Remote Transaction Management Overview
  The method for managing transactions involving remote servers uses a two-phase commit protocol.
• Restrictions on Transaction Management
  Transaction management has savepoints and nested statement restrictions.