Improving SQL Update perfomance

[Luis Rodriguez <luis.rodriguez2@xxxxxxxxx>]

 Hi list,
 
 What would be the best way to improve the performance of
 a SQL Update statement executed with RUNSQLSTM?
 
 I need to run the following SQL for several tables:
 
 UPDATE LIBNAME/TABLE  SET
 	Field1 = round(field1 / 1000, 2),
 	Field2 = round(field2 / 1000, 2),
         ...
 	Fieldn = round(fieldn / 1000, 2);
 
Each one of these tables can have several thousands of
records. One of them has 15 million of records, and the
process is VERY slow.
 
Thanks in advance,
 
Luis


Luis Rodriguez

IBM Certified Systems Expert
eServer i5 iSeries Technical Solutions


      ____________________________________________________________________________________
Never miss a thing.  Make Yahoo your home page. 
http://www.yahoo.com/r/hs