Progress
DataServer for
Microsoft SQL Server
Guide


Share Locks

The different isolation levels will determine what kind of share locks will take effect. In SQL Server™, a repeatable read and serializable isolation level are synonymous.

The DataServer ignores the 4GL SHARE–LOCK option when used in Progress statements. Instead, share locks are governed by the data source and the available ODBC isolation levels. If you wish to change the share lock behavior, you may be able to do so by changing the isolation level at connection time using the -Dsrv parameter.

When you read records with a 4GL statement, regardless of whether you include the SHARE–LOCK option, the MSS data source typically behaves as follows:

If you hold a record with a share lock, other users can usually access that record and apply a share lock, but this is dependent on the isolation level they have selected. Refer to the transaction and locking references in the Microsoft ODBC Programmer’s Reference or data source reference manuals for more information.


Copyright © 2004 Progress Software Corporation
www.progress.com
Voice: (781) 280-4000
Fax: (781) 280-4095