Re: Q: INFORMIX Locking vs DB2 Locking

Posted in 1998

Peter Lancashire — Fri, 05 Jun 1998 17:43:37 +0100 — source: Informix-list mailing list archive (1991-1998)

Jay Aymond wrote: > > Volker Fraenkle <VFraenkle@cs-controlling.de> wrote: > > >Hello, > > > >I heard, DB2 is able to hold record locks after commit. Is there a > >possibility for INFORMIX, too? > > > >Thanks, > >Volker > > > >-- > >Volker Fraenkle CS Controlling > >Technical Consultant Software Systeme GmbH > > > >E-Mail: VFraenkle@cs-controlling.de > >Phone: +49 7144 8144-0 Riedbachstrasse 5 > >Fax: +49 7144 8144-10 D-74385 Pleidelsheim > > Declare your cursor using the "with hold" option. Not so: the cursor remains open but the locks are released on commit. It says so in the manual. -- Peter Lancashire Information Systems Specialist, Bayer plc Eastern Way, Bury St Edmunds, Suffolk, IP32 7AH, UK Tel: +44-1635-562258, Fax: +44-1635-562281 Mail: Peter.Lancashire.PL1@bayer.co.uk --- My Internet plumbing does not allow me to mail and post news together. Sorry. All opinions are my own and not those of Bayer plc. --- Join Infuse, the UK Informix User Group at http://www.infuse.org.uk/