Re: Lock Syntax on Begin-Select

[Rick_Creel@AONCONS.COM]

I encountered the same problem using Oracle on a Unix server.  The various
switch syntaxes shown in the book (such as -LOCK RO) seem to be for SQLBase
only... what ever SQLBase is.  I know it does NOT work for Oracle/Unix
environment.  Not sure what your solution will be.






"htreadwell(contr-comp)" <htreadwell@SNAP.ORG> on 01/04/2000 12:16:52 PM

Please respond to sqr-users@list.iex.net

To:   SQR-USERS@list.iex.net
cc:    (bcc: Rick Creel/IT/Aon Consulting)

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