Rollbacks for Single-Transaction Task Groups

The behavior of a rollback for a failed single-transaction Task Group execution differs according to the interface property.

If execution of a Task Group component for which the Single Transaction property is selected fails, the behavior of a subsequent rollback depends on the interface you set. If the interface is:

ODBC – all statements in the Task Group are rolled back.
Sybase – only the statement that failed is rolled back, and the statements preceding it remain committed.