AutoPreCommit connection parameter [AutoPreCommit]

Forces each statement to COMMIT before execution.

ODBC

NO

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.

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_2\demo\iqdemo.db
AutoPreCommit=Y
UserID=DBA
Password=SQL