Re: update question

In article <3d7ruh$8fk@emory.mathcs.emory.edu> inf_bb@hermes1.sps.mot.com "Bob Baskett" writes: > netters, > > given that you have two tables that are defined exactly that same, > table1 and table2. where table1 has 5 million rows and table2 has > 50000 rows of data. table2 holds data that is to be inserted or > used to update the data in table1. using ISQL only, what is the > best way to accomplish this task. also, i dont want to delete from > the table1 table since we are reporting from this table 24x7. > i have tried the following sql but it runs into long transactions > (we have many large logs....), both tables have indexecs on > wafer_lot and lot_class. we have a 4gl program that handles this > nicely, but it uses rowid (which disappear in 7.x and higher > versions of online), so i dont want to use rowid: > > A 'cute' way to do this type of thing : Write an ace report that will generate the update/insert statements you want, run this , outputing to a file with a .sql extension then run the script (isql dbname filename). Each of the updates should be done as sigleton transactions and so should not cause long transactions. The other nice thing about this way is that you can pick up any values from any tables you need for the update -- Mike Aubury