Transaction Command (ODBC Only)
Manually back-out database changes.

rollback

Description

Use this command in conjunction with the "autocommit off" to back-out all pending database changes in a single step. The application must have been logged into a data source using the login command, otherwise the following error message will be displayed:

Error: Not connected to database

 

If the rollback is success, the prompt is return, otherwise the following message will be returned:

Error: Rollback failed

 

Note. For other database types the rollback command will be passed onto the DBMS, which may have the same effect depending of the DBMS.