DisableROLock

(Microsoft SQL Only)Disables a lock that is created in a read-only cursor.

Syntax

Disablerolocks=[yes |no]

Default

no

Values

  • yes disables the lock on the read-only cursors.

  • no retains the lock on the read-only cursors.

Comments

Sybase recommends setting DisableROLock to yes for increased concurrency when accessing shared tables. However, applications opening multiple cursors on the same table within the same connection must set DisableROLock to yes to avoid this error:
Connection is busy with results for another hstmt
Parent topic: Target Interaction Properties