Hi

Can you please let me know syntax for using Update using with Clause.I am able to use insert with With Clause.But Update is not working .

Please help

Thanks

Kindly explain in detail why you want to UPDATE using the WITH clause only and why not a simple UPDATE with JOIN......

It may be possible that you don't require the WITH clause in the first place.

Actually I am using 10 temporary tables and it involves a complicated logic.
So I cannot avoid using with clause.

Please advise

You cannot use "WITH common table expression" clause in an UPDATE statement.

Please see syntax diagram of UPDATE statement
in "DB2 Version 9 for Linux, UNIX, and Windows SQL Reference Volume 2".

Thanks so much.
As mentioned I have used with clause with 10 temp tables...
In my where condition of select clause I have a condition as mentioned below:

where (( x.account_sk =tm.account_sk and y.ACCOUNT_SK=tm.account_sk ) ---------------------(1)
or
x1.account_sk =tdt.account_sk and y1.account_sk=lft.account_sk ))---------(2)

If I give condition (1) ,(2) seperately it works fine,when I include or in between ,query doesnt return any result****ns for longer time

There is no cartesian product.

Please help

Have a look at the MERGE statement. This may be more suitable for you.