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 COMMIT
statement to make the changes to the database permanent.
You cannot roll back
the changes to the database after the COMMIT statement is executed.
Note: The COMMIT statement has
an effect only when autocommit functionality is off. In most data
sources, autocommit functionality is on by default. Refer to the server
administration documentation for information about how to turn off
autocommit functionality. For example, see the
SAS Federation
Server: Administrator’s Guide for the appropriate
connection option to the FedSQL driver. For the FEDSQL procedure,
see the
Base SAS Procedures Guide.
Note: For the SASHDAT data source,
the COMMIT statement does not permanently alter the database. Instead,
it closes the SASHDAT table, either when a statement is unprepared
or when the connection is disconnected (default), depending on the
setting of the COMMIT= connection option. If a SASHDAT table remains
open when autocommit functionality is on, COMMIT can be used to close
it.