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....
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Update and append queries 2
update undo query 1
Limiting Records in an Update Query 5
Using Append Queries with Linked Tables 3
Select, update query--same query, different result 7
Queries take FOREVER to run - ??? 3
Update query issue 0
update query ODBC--call failed 3

Back
Top