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 with remote tables is handled somewhat differently than it is for local Sybase IQ tables. 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 11.0.1 > SQL Anywhere Server - SQL Usage > Creating Databases > Using transactions and isolation levels.

For a general discussion of transactions in Sybase IQ, see 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.