Update with join statement not working in DB2

Sphenix wrote: > > UPDATE A > SET A.ID = '?' + A.ID > FROM TABLEA A > LEFT OUTER JOIN TABLEB B ON > A.INDEX = B.INDEX > WHERE B.DUP_ID IS NULL > > > seems like update with join statement not working in DB2 version 5 > > any idea to update ...

dbaspot.com