When your program has
completed all of the statements in the transaction, you must explicitly
terminate the transaction using COMMIT or ROLLBACK. You use a ROLLBACK
statement to roll back, or undo, the changes that have been made since
the start of the transaction.
You cannot roll back
the changes to the database after a COMMIT statement is executed.
The ROLLBACK statement
has an effect only when autocommit functionality is off. For most
data sources, autocommit functionality is on by default. See the server
administration documentation for information about how to turn off
autocommit functionality. For example, see
SAS Federation
Server: Administrator’s Guide for the appropriate
connection option to the FedSQL driver. For the FEDSQL procedure,
see
Base SAS Procedures Guide.
Note: ROLLBACK has no effect on
the SASHDAT data source.