Re: INSERT cursor -- part two

Carlson@WHSmith wrote: > > Added the FLUSH -- (thanks for the reminder, Gary). Shouldn't matter -- the CLOSE and the COMMIT both imply a flush. > Added a row check to the number of rows processes and to > sqlca.sqlerrd[3] after PUT and FLUSH. > > All seemed right with the world . . until . . . > > I noticed that a grouping took much longer than normal to complete. > Cross-referenced it to the log and found that a checkpoint occurred, > with another large update job running. So far, so normal. > From that point on, my row counts were off and no commits took place. Weird. > Any ideas about what happened? This is all so new to me . . . <G> Did you have WHENEVER ANY ERROR STOP set? Do you have CALL STARTLOG() or CALL fgl_startlog() in your code? Do the log files say anything useful? -- Jonathan Leffler (jleffler@informix.com, jleffler@earthlink.net) Guardian of DBD::Informix v0.60 -- see http://www.perl.com/CPAN #include <disclaimer.h>