Setting AutoCommit and Lock in the database profile

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.

StepsTo set AutoCommit and Lock (Isolation Level) in a database profile:

  1. Display the Database Profiles dialog box.

  2. 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.

  3. Select the name of the profile you want and click Edit.

    The Database Profile Setup dialog box for the selected profile displays.

  4. On the Connection tab page, supply values for one or both of the following:

    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.

  5. (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.

  6. Click OK to close the Database Profile Setup dialog box.

    DataWindow Designer saves your settings in the database profile entry in the registry.