INSERT cursors
Posted in 1998
I've looked it up in DejaNews and I double-checked the manual . . . still a bit clueless . . . I'm in the process of speeding up a very long batch job and I need a bit of help from the more experienced 4gl people out there. I noticed that a certain function inserts rows into a given table. What I determined was that an insert cursor might be a bit more effective. So far (no surprise) I've found out that it's faster. The only problem is that . . . how can I verify that the number of rows I PUT equals the number of rows I actually committed to the database? For example, I know that I PUT 168 rows, and I can see that they were committed, but how can my program verify this information as it runs? TIA John Carlson Informix DBA WH Smith, Inc.