How to run an update query without cacheing ?

  • Thread starter Thread starter Todd Heiks
  • Start date Start date
T

Todd Heiks

Hi-

I have this suspicion that if I were to run an update query w/o cacheing an
undo file, the whole thing would run faster.
Does this sound reasonable?
Is it possible?

I am running MSA97 / MSA03 and linking via ODBC to db2/400. I want to
update many records and it takes all day. When I run an sp on the 400 it is
done before the <enter> key comes up. I think the reason for the lag is
that MSA is writing the records out somewhere for an undo.

Thanx
Todd
 
There is a property 'Use Transaction' on an updating query, it is default set to yes. Try No then you won't get the undo possibility....
 
Back
Top