Actions Performed by ROLLBACK with Embedded SQL - Analytics Database - Teradata Vantage

ROLLBACK performs the following additional actions when used within an embedded SQL application:

1. Discards dynamic SQL statements prepared within the current transaction.
2. Closes open cursors.
3. Cancels database changes made by the current transaction.
4. Sets SQLCODE to zero when ROLLBACK is successful.
5. Sets the first SQLERRD element of the SQLCA to 3513 or 3514, depending on whether abort_message is specified.
6. Returns an abort message in the SQLERRM field of the SQLCA if you specify a WHERE clause.
7. Terminates the application program connection (whether explicit or implicit) to the database if the RELEASE keyword is specified.