ASA SQL User's Guide
Accessing Remote Data
Transaction management and remote data
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.