Re: Does Informix do Versioning Read-Only Transactions?

In article <3l6a0l$u5@sword.eng.pyramid.com> graeme@pyramid.com "Graeme Sargent" writes: > D. Erway (derway@ndc.com) wrote: > > : Does anyone know if any versions of Informix, (maybe the latest - 7), do > : Versioning Consistency Control like Oracle 7 does? > > No, Informix 7.1 does not do Versioning. But then, neither does > ORACLE7. > > From "Informix Guide to SQL 7.1 Tutorial" pp7-15 para 5: "The definitions for ANSI Serializable, ANSI Repeatable Read, and Informix Repeatable Read isolation levels are all the same. The Repeatable Read isolation level asks the database server to put a lock on every fow the program examines and fetches. the locks that are placed are shareable for an ordinary cursor and promotable for an update cursor. The locks are placed individually as each row is examinted. They are not released util the cursor closes or a transaction ends." Hope this helps -- Graeme Burnett Xinit Open Systems Limited (+44) 171 586 5855