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 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 ”Using transactions and isolation levels” in SQL Anywhere Server - SQL Usage.
For a general discussion of transactions in Sybase IQ, see Chapter 10, “Transactions and Versioning,” in System Administration Guide: Volume 1.
