Re: insert cursors
It's not so much that it cannot be used in 4GL, just that there is no 4GL syntax support for INSERT or PUT cursors. However, note that 4GL compiles down to ESQL/C so the library support is there, you just have to write the function or functions that implement the insert cursor using ESQL/C and call it/them from 4GL. You could either write the entire insert processing module in ESQL/C or you could just package up the PREPARE, DECLARE, & OPEN, PUT, and FLUSH & CLOSE calls in separate 4GL callable ESQL/C functions. Since ESQL/C supports PREPARE and DESCRIBE and also supports naming prepared statements and cursors using string variables you could actually write a generic library of using PUT cursors in 4GL that handles partial transactions, etc. Art Art S. Kagel Advanced DataTools (www.advancedatatools.com) Blog: http://informix-myview.blogspot.com/ Disclaimer: Please keep in mind that my own opinions are my own opinions and do not reflect on my employer, Advanced DataTools, the IIUG, nor any other organization with which I am associated either explicitly, implicitly, or by inference. Neither do those opinions reflect those of other individuals affiliated with any entity with which I am affiliated nor those of the entities themselves. On Tue, Feb 12, 2013 at 10:26 AM, Randall Young (ADE) < 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**** > > ** ** > > Thanks.**** > > ** ** > > --**** > > Randall Young**** > > randall.young@arkansas.gov**** > > ** ** > > “Blessed are we who can laugh at our surroundings for we shall never be > considered completely sane.”**** > > ** ** > > _______________________________________________ > Informix-list mailing list > Informix-list@iiug.org > http://www.iiug.org/mailman/listinfo/informix-list > >