DisableROLock

NoteThis property applies to Microsoft SQL only.

Disables a lock that is created on a read-only cursor.

Syntax

Disablerolocks=[yes | no]

Default

no

Values

Comments

Sybase recommends setting DisableROLock=yes for increased concurrency when accessing shared tables. However, applications opening multiple cursors on the same table within the same connection will need to set DisableROLock=yes to avoid this error:

Connection is busy with results for another hstmt