ODBC_ROLLBACK Procedure

Cancels changes for an ODBC transaction.

Restriction: See "Supported Platforms Guide" on the PV-WAVE Documentation website to check if this function is available on your operating system.

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