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 Adaptive Server Anywhere, although there are some differences.
For a general discussion of transactions in Adaptive Server Anywhere, see “Using Transactions and Locks” in the Adaptive Server Anywhere User's Guide. For a general discussion of transactions in Sybase IQ, see Chapter 10, “Transactions and Versioning.”
