AutoPreCommit connection parameter [AutoPreCommit]

To force each statement to COMMIT before execution.

ODBC

NO

By default, statements issue a COMMIT after execution.

You can set the AutoPreCommit option to YES (Y) to turn on commit before execution or NO (N) to turn it off in the Windows (XP/2000) registry. For example, the following causes each statement to COMMIT before execution:

[Sample DSN]
DatabaseFile=c:\sybase\ASIQ-12_6\demo\asiqdemo.db
AutoPreCommit=Y
UserID=DBA
Password=SQL