Path: utzoo!utgpu!news-server.csri.toronto.edu!rpi!usc!apple!well!gatynen
From: gatynen@well.sf.ca.us (Gerard Tynen)
Newsgroups: comp.databases
Subject: Re: Oracle CURSORS useless ?
Message-ID: <25784@well.sf.ca.us>
Date: 29 Jun 91 23:06:26 GMT
References: <1991Jun26.033043.22948@sunaus.oz> <1991Jun26.234724.18956@informix.com>
Organization: Whole Earth 'Lectronic Link, Sausalito, CA
Lines: 12

>>DBMS I've ever seen closes all open cursors [SQL/DS, DB2, Ingres ...] when
>>a commit is issued.
>>
>
>Not Informix.  In our 4.0 product you can declare a cursor with hold
>and it won't be closed during a commit.

Also IBM Database Manager can declare cursors "with hold", 
and their positioning is maintained across commits...


-GT