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

gburnore@netcom.com (Gary L. Burnore) writes: >Jack Parker (jparker@hpbs3645.boi.hp.com) wrote: >: > >: > 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 The clock speed and RAM capacity may have an impact on whether "brute force" or loop method is used. If you are running a 10Mhz system with 4MB RAM (AT&T 3B2/400), the "brute force" me thod bombs out. I had infinitely more satisfactory results with a loop. -- Harry Caughey | My ability to communicate with you Virginia Beach, Virginia | is only as good as your ability to caughey@infi.net | communicate with me. Have a nice day.