Relay-Version: version B 2.10 5/3/83; site utzoo.UUCP
Path: utzoo!utgpu!water!watmath!clyde!rutgers!husc6!seismo!mcvax!ukc!onion!riddle!news
From: news@riddle.UUCP
Newsgroups: comp.databases
Subject: Scrolling cursors in Informix
Message-ID: <462@riddle.UUCP>
Date: Tue, 11-Aug-87 09:32:58 EDT
Article-I.D.: riddle.462
Posted: Tue Aug 11 09:32:58 1987
Date-Received: Sat, 15-Aug-87 18:04:42 EDT
Reply-To: news@riddle.UUCP (UNIX Netnews)
Distribution: world
Organization: Sphinx Ltd., Maidenhead, England
Lines: 16


For your information, Informix 4GL version 1.10 and the
corresponding version of ESQL/C, version 2.10, both provide the
concept of scrolling cursors -- which do precisely what you want.
(PERFORM has been re-written to use SQLEXEC, and it behaves as before.
There is another new product, SQL-TURBO, which is an alternative to
SQLEXEC, so PERFORM had to be made to use SQLEXEC, and SQLEXEC had to
support scrolling cursors.)

I don't know whether the commit/rollback problem has been
attended to.

(And, yes, the company I work for does sell Informix products.
But I haven't told anybody I've sent this stuff. Yet!)

Jonathan Leffler (john@riddle.UUCP)	-- My views are my own