Isolation
database parameter
Description
Sets the isolation level to use when connecting to the
database.
In multiuser databases, transactions initiated by different users
can overlap. If these transactions access common data in the database,
they can overwrite each other or collide.
To prevent concurrent transactions from interfering with each
other and compromising the integrity of your database, you can set the
isolation level when you connect to the database. Isolation levels are
used by .NET Framework data providers when performing a
transaction.
PowerBuilder uses the Isolation database parameter to allow you to
set various database lock options. Each value corresponds to an
isolation level defined in the .NET Framework.
When to specify the Isolation value
You must set the Isolation value before you connect to the
database. The Isolation value takes effect only when the database
connection occurs. Changes made to the Isolation value after the
connection occurs have no effect on the current connection.
Applies to
ADO.NET
Syntax
|
1 |
Isolation='value' |
|
Parameter |
Description |
|---|---|
|
value |
A string specifying the isolation level. Values
|
Default value
The default lock value depends on how your database is configured.
For information, see your DBMS documentation.
Examples
Example 1
To set the Isolation value to RC (Read Committed):
-
Development environment
Select Read Committed from the Isolation Level drop-down list
in the Database Profile Setup dialog box. -
Application
Type the following:
1SQLCA.DBParm="Isolation='RC'"
Using the example in code
If you specify Isolation Level in your database profile, the
syntax displays on the Preview page in the Database Profile Setup
dialog box. You can copy the syntax from the Preview page into your
code.