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:
SQLPREP(1)"INSERT INTO mytable VALUES ('10', 'Sample Record')"
Note that the SQLCOMMIT verb has no effect on data sources that do not support transaction tracking.