Neoview Control Query Default (CQD) Reference Guide (R2.5)

Neoview Release 1.0Introduced in release
Not applicableDeprecated in release
ISOLATION_LEVEL_FOR_UPDATES
Transaction control and lockingCategory
Specifies the default transaction isolation level for these update operations:
INSERT
UPDATE
DELETE
Description
‘READ
UNCOMMITTED’
‘READ COMMITTED’
‘REPEATABLE READ’
‘SERIALIZABLE’
The default value is ‘READ COMMITTED’ (ANSI).
Values
Set this CQD to READ UNCOMMITTED to prevent users from performing any updates.Usage
Not applicableProduction usage
When set, this CQD prevents users from doing any of these update operations:
INSERT
UPDATE
DELETE
Impact
ServiceLevel
Works with the ISOLATION_LEVEL setting. Both settings are READ COMMITTED by
default. ISOLATION_LEVEL can be set to READ UNCOMMITTED. This CQD still remains
READ COMMITTED. You can change it to READ UNCOMMITED to prevent queries
running at the service level to not perform any updates.
Conflicts/Synergies
Not applicableAddressing the real
problem
Neoview Release 1.0Introduced in release
Not applicableDeprecated in release
46 Managing Isolation Level