Destination-Template Transfer

When a destination-template transfer statement moves data from Adaptive Server to the primary database, the access service automatically sets the StopCondition property to none.

Subsequent commit and rollback processing is determined by whether short or long transactions are in effect:

If short transactions are in effect, the access service issues a commit after each batch, whether or not errors occurred in the request. In this case, each batch of inserts is a unit of work.
If long transactions are in effect, the access service issues a commit at the end of the entire transfer. Because StopCondition is set to none, the access service never issues a rollback. In this case, the entire transfer is a unit of work.