[Date Prev][Date Next][Thread Prev][Thread Next]
[Author Index]
[Date Index]
[Thread Index]
[SQR-USERS Info]
[SQRUG Home Page]
Lock Syntax on Begin-Select
- Subject: Lock Syntax on Begin-Select
- From: "htreadwell(contr-comp)" <htreadwell@SNAP.ORG>
- Date: Tue, 4 Jan 2000 12:16:52 -0500
We have an SQR program running against a Sybase database that is locking out
another process . To resolve the lock, we attempted to make the SQR query
read only by using the following syntax:
Begin-Select -LOCK RO
The syntax is correct based on the manual, however, when we tried to compile
the SQR program, we got a 3721 error - Bad param found on 'BEGIN-SELECT'
line.
Is the syntax database dependent? Can we use a " For Read Only " statement
somehow (we tried this, but still got the lock)? Any suggestions on how to
affect the isolation level for Sybase within the SQR program?
Many thanks,
Huey