The AutoCommit and Lock (Isolation Level) preferences are properties of the default Transaction object, SQLCA. For AutoCommit and Lock to take effect in the PowerBuilder development environment, 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 PowerBuilder 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 PowerBuilder 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 PowerBuilder, click the Preview tab if you want to see the PowerScript connection syntax generated for Lock and AutoCommit.
PowerBuilder generates correct PowerScript connection syntax for each option you set in the Database Profile Setup dialog box. You can copy this syntax directly into a PowerBuilder application script.
For instructions, see “Copying DBParm syntax from the Preview tab”.
Click OK to close the Database Profile Setup dialog box.
PowerBuilder saves your settings in the database profile entry in the registry.
