news@riddle.UUCP (08/11/87)
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