ODBC_COMMIT Procedure

Saves changes for an ODBC transaction.

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

Usage

ODBC_COMMIT, 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_COMMIT saves all changes which are pending on the current connection. To cancel the changes, use the ODBC_ROLLBACK procedure.

Currently, the ODBC Connection does not support savepoints or nested transactions.

Note: Certain DBMS may allow COMMITs to occur through the ODBC_SQL command, but these are not recommended in ODBC. For best results, please use ODBC_COMMIT and ODBC_ROLLBACK.

Example