Re: Lock Syntax on Begin-Select

[Peter Alan Burton <pburton@BRIO.COM>]

Huey,

As documented -LOCK is for SQLBase only.

Peter


On 4 Jan 00, at 12:16, htreadwell(contr-comp) wrote:

Date sent:              Tue, 4 Jan 2000 12:16:52 -0500
Send reply to:          sqr-users@list.iex.net
From:                   "htreadwell(contr-comp)" <htreadwell@SNAP.ORG>
Subject:                Lock Syntax on Begin-Select
To:                     SQR-USERS@list.iex.net

> 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