Re: Informix Row Locking

Posted in 1998

Topics: Transactions, Locking & Isolation

Noel Teis — Thu, 22 Oct 1998 13:04:34 +1000 — source: Informix-list mailing list archive (1991-1998)

Yes, select for update does work with informix. Forget about the no wait. 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> > 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 -- ____________________________________________________________________ Noel Teis Omnix Pty Ltd. Software Development Manager ACN 010 130 864 noelt@omnix.com.au P.O.Box 263 Tel 61-7-32550044 Annerley DC Fax 61-7-32550220 Qld, 4103 http://www.omnix.com.au Australia ____________________________________________________________________