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.
ADO.NET
Isolation='value'
Parameter |
Description |
|---|---|
value |
A string specifying the isolation level. Values correspond to members of the .NET Framework IsolationLevel enumeration:
|
The default lock value depends on how your database is configured. For information, see your DBMS documentation.
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:
SQLCA.DBParm="Isolation='RC'"
