Re: Lock Syntax on Begin-Select

["htreadwell(contr-comp)" <htreadwell@SNAP.ORG>]

Thank you all for your quick and helpful replies. Sorry I misunderstood the
documentation
but do appreciate your help.

We are now modifying the programs updating sequences to try and avoid the
locking.
Thanks again.
Huey


-----Original Message-----
From: htreadwell(contr-comp) [mailto:htreadwell@SNAP.ORG]
Sent: Tuesday, January 04, 2000 12:17 PM
To: SQR-USERS@list.iex.net
Subject: 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