Micro Focus Studio Enterprise Edition Test Server > Programming > Data Access > Database Access > Reference > OpenESQL > Embedded SQL Statements > ROLLBACK

ROLLBACK

Backs out any changes made to the database by the current transaction on the current connection.

Syntax:

>>---EXEC SQL---ROLLBACK----.-WORK---------.------------->
                            +-TRAN---------+  
                            +-TRANSACTION--+

 >---.-----------.---END-EXEC---><  
     +--RELEASE--+

Comment:

If RELEASE is specified and the transaction was successfully rolled back, the current connection is closed.

Example:

EXEC SQL
   ROLLBACK
END-EXEC

EXEC SQL
    ROLLBACK WORK RELEASE
END-EXEC