The AutoCommit and Lock (Isolation Level) preferences are properties of the default Transaction object, SQLCA. For AutoCommit and Lock to take effect in the DataWindow Designer plug-in, you must specify them before you connect to a database. Changes to these preferences after the connection occurs have no effect on the current connection.
To set AutoCommit and Lock before DataWindow Designer connects to your database, you specify their values in the Database Profile Setup dialog box for your connection.
To set AutoCommit and Lock (Isolation Level) in
a database profile:
Display the Database Profiles dialog box.
Click the plus sign (+) to the left of the interface you are using
or
Double-click the interface name.
The list expands to display the database profiles defined for your interface.
Select the name of the profile you want and click Edit.
The Database Profile Setup dialog box for the selected profile displays.
On the Connection tab page, supply values for one or both of the following:
Isolation Level If your database supports the use of locking and isolation levels, select the isolation level you want to use for this connection from the Isolation Level drop-down list. (The Isolation Level drop-down list contains valid lock values for your interface.)
AutoCommit Mode The setting of AutoCommit controls whether DataWindow Designer issues SQL statements outside (True) or inside (False) the scope of a transaction. If your database supports it, select the AutoCommit Mode check box to set AutoCommit to True or clear the AutoCommit Mode check box (the default) to set AutoCommit to False.
For example, in addition to values for basic connection parameters (Server, Login ID, Password, and Database), the Connection tab page for the following Sybase Adaptive Server Enterprise profile named Sales shows nondefault settings for Isolation Level and AutoCommit Mode.
(Optional) In DataWindow Designer, click the Preview tab if you want to see the connection syntax generated for Lock and AutoCommit.
DataWindow Designer generates correct connection syntax for each option you set and for your preferred language in the Database Profile Setup dialog box. You can copy this syntax directly into your code.
Click OK to close the Database Profile Setup dialog box.
DataWindow Designer saves your settings in the database profile entry in the registry.
