17.05 - Actions Performed by ROLLBACK with Embedded SQL - Advanced SQL Engine - Teradata Database

Teradata Vantage™ - SQL Data Manipulation Language

Advanced SQL Engine
Teradata Database
Release Number
Release Date
January 2021
Content Type
Programming Reference
Publication ID
English (United States)

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.
Environment Preprocessor Action When a LOGON/CONNECT Request Does Not Precede the Next SQL Request
Mainframe-attached Attempts to establish an implicit connection.
Workstation-attached Issues a No Session Established error.