Configuration Command (ODBC only)

Control commit mode.

autocommit {on|off} 

Description

This command controls the commit mode. When autocommit is on, all updates, inserts and deletes to a table are immediate, which could leave the database in an inconsistent state, if more than a single table needs to be changed for a particular transaction. To ensure all the changes are actioned at the same time, the autocommit mode needs to be set to off, then a commit command must be issued to action the changes in a single step, once the transaction is complete. It is also possible to back-out of changes by using the rollback command. Also, when autocommit is set to off, any uncommitted changes will be backed out, when the database is disconnected when using the stopdb command, which is automatically issued when the application is stopped.

The default setting is on.

The application must have been logged into a data source using the login command, otherwise the following error message will be displayed:

Error: Not connected to database

Example

send "autocommit on\n" to SQL