[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



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