DB2 update using CTE

[tekedge]

Hi,

I have to do an update using a query which uses CTE .
Could any body please tell me how I can do an update.
I am unable to update if I replace the final select with an update one.

Thanks in advance

Jay.

[Roger Barney]

Look here

http://groups.google.ca/group/comp.databases.ibm-db2/browse_thread/thread/105694324f276587