ODBC_COMMIT Procedure
Saves 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_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
ODBC_COMMIT, connect_handle
See Also
