AutoPreCommit Connection Parameter [AutoPreCommit]

Forces each statement to commit before execution.

Usage

ODBC

Default

No

Description

By default, statements issue a commit after execution. When AutoPreCommit = Yes commit statements are issued before each select statement, so that users can always see the latest version of all database objects.

Example

You can set the AutoPreCommit option to Yes to turn on commit before execution or No to turn it off. Set this option in theĀ .odbc.ini file or on the Advanced tab of the Connect dialog.

For example, this causes each statement to commit before execution:

[Sample DSN]
DatabaseFile=c:\Program Files\Sybase\IQ-16_0\demo\iqdemo.db
AutoPreCommit=Y
UserID=DBA
Password=SQL