Serge Rielau wrote:
> The way I understand it the OP tries to maintain a derived column
> SUM(col2) OVER(PARTITION BY col1) within the table.
> That is any time one of the rows in the group is changed all others need
> to be updated.
> Questionable design.... Perhaps reading up on materialized views would
> be in order.
Actually I spoke in haste. Ignore this part. It's wrong.
--
Serge Rielau
DB2 Solutions Development
IBM Toronto Lab
WAIUG Conference
http://www.iiug.org/waiug/present/Forum2006/Forum2006.html
Received on Mon Nov 20 2006 - 12:03:22 CST
