I don't know how a CTE might be used effectively in an UPDATE statement. From the <a href="http://publib.boulder.ibm.com/infocenter/iseries/v7r1m0/index.jsp?topic=/db2/rbafzcomtexp.htm">V7.1 SQL Reference</a>:<ul>
<li>The table name of a common table expression can only be referenced in the select-statement, INSERT statement, or CREATE VIEW statement that defines it.</li>
The same wording is in earlier manuals.
Last Wiki Answer Submitted: September 1, 2010 11:28 pm by TomLiotta107,845 pts.
All Answer Wiki Contributors: TomLiotta107,845 pts.