Re: Slow Cursor

Nils Myklebust wrote: > > On Mon, 28 Sep 1998 00:41:20 GMT, justabill@school.house.rocks > (justabill) wrote: > > >I have a program that does the following [SNIP] > There are two problems with this: > a. If the primary key is more than one field it will not work and > there is no easy way to make it work, at least not in a general way. You can solve this by saving ROWID into the original temp table of rows affected (insert and update both report rowid for a single row transaction in sqlca). This will work for any non-fragmented table and with a little elbow bending for fragmented tables to which the pseudo-rowid column has been added. > b. The whole delete will now be done in one transaction. That may lead > to a long transaction problem. If that is an issue I would try to > increase log space or optionally run this without transactions if that > is possible. Art S. Kagel