Re: Does Informix do Versioning Read-Only Transactions?

graeme@pyramid.com (Graeme Sargent) wrote: > > 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. ^^^^^^^^^^^ WRONG, Oracle7 (6,5,4) does (did) statement level or transaction level multi-versioning. Statement Level read consistency is ALWAYS enforced (readers/writers NEVER block each other). Transaction level read consistency, achieved by multi-versioning, may be done for read only transactions. > > : Or any other versioning transaction control like maybe Interbase? > > Now *that's* versioning! > > -- > graeme > -- > Disclaimer: The author's opinions are his own, and not necessarily > those of Pyramid Technology Ltd. or Pyramid Technology Inc. > --------------------------------------------------------------------------- > -m------- Graeme Sargent Voice: +44 (0)252 373035 > ---mmm----- Senior Database Consultant Fax : +44 (0)252 373135 > -----mmmmm--- Pyramid Technology Ltd. Telex: Tell who??? > -------mmmmmmm- Farnborough, Hants GU14 7PL Email: graeme@pyra.co.uk > --------------------------------------------------------------------------- > We have the technology. The tricky bit is learning how to use it. Thomas Kyte tkyte@us.oracle.com Oracle Government