Rolls a user-defined transaction back to the last savepoint inside the transaction or to the beginning of the transaction.
rollback {transaction | tran | work}
[transaction_name | savepoint_name ]
Adaptive Server notifies Component Integration Services when it receives a rollback transaction command and Component Integration Services attempts to roll back work associated with remote servers in the current transaction.
Multiple remote servers can be involved in a single transaction, each with its own unit of work, which is associated with the Adaptive Server unit of work.
Remote work is rolled back before local work.
Work performed by transactional RPCs is included in the local transaction and can be rolled back if the remote server supports RPC’s within transactions.
transaction_name and savepoint_name are not currently used by Component Integration Services.
files are not part of transaction management. They cannot be committed or rolled back.
directories are not part of transaction management. They cannot be committed or rolled back.
rollback in the Reference Manual
