Re: Lock Syntax on Begin-Select

[Wes Williams <wes.williams@HS.UTC.COM>]

-lock is only for SQLBase e.g. Centura formally known as Gupta and will not work with Sybase.

Wes

Wes Williams
Hamilton Sundstrand
wes.williams@hs.utc.com

>>> "htreadwell(contr-comp)" <htreadwell@SNAP.ORG> 01/04 11:16 AM >>>
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



**********************************************************************
This email and any files transmitted with it are confidential and
intended solely for the use of the individual or entity to whom they
are addressed. If you have received this email in error please notify
the system manager.


**********************************************************************