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