<div>
Yep, you only need &quot;with&quot; once, after that each cte is separated by a comma. <br />
<i>This is as specified in the SQL Standards by the way, not specific to DB2</i><br />
<br />
no points please
</div>


Yep, you only need "with" once, after that each cte is separated by a comma.
This is as specified in the SQL Standards by the way, not specific to DB2

no points please

<div>
Awesome thank you. &nbsp;Having trouble getting it to work in DB2 so got around it by just using code and not creating calculated values.
</div>


Awesome thank you.  Having trouble getting it to work in DB2 so got around it by just using code and not creating calculated values.

<div>
If you'll post the code, I'm sure we can show you how to write it as a CTE.
</div>


If you'll post the code, I'm sure we can show you how to write it as a CTE.

<div>
<div class="content wysiwyg-content">
WITH SFPMS2 AS (<br />
WITH SFPMS AS (Select ....<br />
<br />
I am getting red Xs and no explanation. &nbsp;Can you now do thius in DB2?
</div>
</div>


WITH SFPMS2 AS (
WITH SFPMS AS (Select ....

I am getting red Xs and no explanation.  Can you now do thius in DB2?

Nested WITH clauses in DB2 sql

IBM DB2 is a family of relational database server products developed by IBM that have been extended to support object-relational features and non-relational structures like JSON and XML. There are three main products in the DB2 family: DB2 for Linux, UNIX and Windows (informally known as DB2 LUW), DB2 for z/OS (mainframe), and DB2 for i (formerly OS/400), plus a version for IBM's Virtual Storage Extended (VSE) operating system.

SQL (Structured Query Language) is designed to be used in conjunction with relational database products as of a means of working with sets of data. SQL consists of data definition, data manipulation, and procedural elements. Its scope includes data insert, query, update and delete, schema creation and modification, and data access control.