Re: Does Informix do Versioning Read-Only Transactions?

Thomas J. Kyte (tkyte@us.oracle.com) wrote: : 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. Conceded. -- 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.