Re: Informix Row Locking
On 21 Oct 98, at 12:59, P.Silva wrote:
> Does anyone know the equivalent syntax for informix 7.23 (fc4) for this:
>
> (Oracle 7)
> SELECT * FROM myTable WHERE myConds FOR UPDATE WITH NOWAIT
SET LOCK MODE TO NOWAIT;
SELECT * FROM mytable WHERE <...> FOR UPDATE;
> SELECT FOR UPDATE locks rows on Oracle. I know this isn't
possible in MS
> SQL Server. Does Informix supports it? Thanks in advance... P.Silva
Yes, Informix does support row-level locking and supported it long
before Oracle did... :-p
--
Ciao,
Billy
/Group Managing Director, The West Solutions Group: http://www.west.co.za
\\ Drivel @ http://www.west.co.za/tasteless/
/
\\ "Granted, Mr Wheeler's ideas are stupid and unreasonable, but he does own the company and I
/ think we should go along with him..."
\\________________________________________________________________________________________________