AutoPreCommit connection parameter [AutoPreCommit]

Function

To force 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 (Y) to turn on commit before execution or NO (N) to turn it off. Set this option in the .odbc.ini file or on the Advanced tab of the Connect dialog.

For example, the following causes each statement to COMMIT before execution:

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