Re: What's the fastest way to...

> > Re: > >The brute force method is going to be the best I would think since >you need > >to update ALL rows. Since that is the case, shoot the 'where 1=1' - >you > >don't need it. > > Earlier in the question, the asker stated he was using 4gl for the mass > update. In 4gl if an update or delete is applied without a where clause, > informix assumes it is a mistake and the program crashes. To do a mass > update/delete in a 4gl program, a where clause that is always true (such as > where 1=1) is needed. > > Interesting. Our version of 4gl (4.10.UD2) just did an update against 241 rows without a where clauseand without complaint. I also use a DELETE FROM table without a where clause consistently without error. C'mon back j. _____________________________________________________________________________ Jack Parker | Hewlett Packard, BSMC Boise, Idaho, USA| If you put all of the lawyers in jparker@hpbs3645.boi.hp.com | this country end to end, (208) 396-5388 (W) (208) 384-1623 (H) | it would be a good thing. _____________________________________________________________________________ Any opinions expressed herein are my own and not those of my employers. _____________________________________________________________________________