ODBC Connection User Guide > Reference > ODBC_ROLLBACK Procedure
  

ODBC_ROLLBACK Procedure
Cancels changes for an ODBC transaction.
Usage
ODBC_ROLLBACK, connect_handle
Input parameters
connect_handle—A connection handle established with ODBC_CONNECT.
Keywords
Env_handle—If set, this keyword indicates that the input parameter is an environment handle (established with ODBC_INIT). In this case, all transactions on all connections associated with this environment handle are affected.
Discussion
ODBC transactions such as UPDATE, INSERT, and DELETE can cause changes in the data on the server. Often, a user will want to review these changes and decide whether to save or cancel them. ODBC_ROLLBACK cancels all the changes which are pending on the current connection. To save the changes, use the ODBC_COMMIT procedure.
Currently, PV‑WAVE: ODBC Connection does not support savepoints or nested transactions.
 
note
Certain DBMS may allow COMMITs to occur via the ODBC_SQL command, but these are not recommended in ODBC. For best results, please use ODBC_COMMIT and ODBC_ROLLBACK.
Example
ODBC_ROLLBACK, connect_handle 
See Also
ODBC_COMMIT

Version 2017.0
Copyright © 2017, Rogue Wave Software, Inc. All Rights Reserved.