RE: insert cursors

Thanks for your prompt response. I did manage to get the insert cursor working under 4GL. Unfortunately, it didn't seem to increase the speed on the insert. The last time I tried this method was in late 1990s. Perhaps the hardware and the storage devices are much faster these days. Thanks for you help. -- Randall Young randall.young@arkansas.gov<mailto:randall.young@arkansas.gov> "Blessed are we who can laugh at our surroundings for we shall never be considered completely sane." From: informix-list-bounces@iiug.org [mailto:informix-list-bounces@iiug.org] On Behalf Of Jonathan Leffler Sent: Tuesday, February 12, 2013 10:54 AM To: Randall Young (ADE) Cc: Informix List - IIUG Subject: Re: insert cursors On Tue, Feb 12, 2013 at 7:26 AM, Randall Young (ADE) <Randall.Young@arkansas.gov<mailto:Randall.Young@arkansas.gov>> wrote: I have had some good experience with insert cursors in esql/c. The documentation seems to say that I cannot use this feature in 4GL. Is there some analogous way to speed up inserts in 4GL? IBM INFORMIX-4GL Version 7.50.FC5 DB-Access Version 11.50.FC5 INSERT cursors were added to I4GL at the time they were introduced in ESQL/C, way back in the distant mists of time (circa 1988). They should still be supported. Any documentation to the contrary needs to be reported, please, so we can get it fixed. -- Jonathan Leffler <jonathan.leffler@gmail.com<mailto:jonathan.leffler@gmail.com>> #include <disclaimer.h> Guardian of DBD::Informix - v2013.0118 - http://dbi.perl.org "Blessed are we who can laugh at ourselves, for we shall never cease to be amused."