SQLCOMMIT Verb - Commit Current Transaction
Syntax
SQLCOMMIT(sqlchan{,ERR=lineref})
Description
The SQLCOMMIT verb instructs the connection to commit its current transaction.
An error is returned if the transaction fails or if AUTO_COMMIT mode was
set to ON (default) when the connection was opened using SQLOPEN.
To allow for transactions, the AUTO_COMMIT mode must be set to OFF during
the SQLOPEN call. The following example opens a connection to the MyData
data source with transaction tracking enabled, inserts a new record, then
commits the transaction:
SQLOPEN(1,MODE="AUTO_COMMIT=OFF")"MyData"
SQLPREP(1)"INSERT INTO mytable VALUES ('10', 'Sample Record')"
SQLEXEC(1)
SQLCOMMIT(1)
SQLCLOSE(1)
Note that the SQLCOMMIT verb has no effect on data sources that do not support transaction tracking.