Re: Scroll Cursor for Update

On Fri, 5 Sep 1997, Bill Ennis wrote: > I don't think this restriction exists. [...] It does. It exists in v7, v8, v9, v4, v6, ... It isn't likely to go away. If you want to achieve the equivalent effect, then you use a SCROLL CURSOR which selects just the primary key values (which will identify each row), and then fetch the actual data using a normal, non-scrolling CURSOR FOR UPDATE to fetch each row in turn. > } I'm in the process of rewriting the database access library for one of > } our applications. The original database was proprietary and the new > } database will be Informix-SE. Currently we have v5.x. V7.x is on > } order. > } It appears that v5's dynamic ESQL C does not allow me to open a SCROLL > } CURSOR against a SELECT statment defined as FOR UPDATE. > } Does v7 relax this restriction? > } Steven Yours, Jonathan Leffler (johnl@informix.com) #include <witticism.h>