SAP Knowledge Base Article - Preview

2326265 - Generation order is wrong for views with a CTE query - SAP PD

Symptom

View is created before database, table space and table in the SQL script generated by SAP PowerDesigner if:

  • the table involved in the view query has a table space defined,
  • and this table space has a database assigned,
  • and the view query uses a common table expression (CTE).

Read more...

Environment

  • SAP PowerDesigner (PD) 16.6 PL01
  • IBM DB2 for z/OS

Product

SAP PowerDesigner all versions

Keywords

db2mvs, associated, 799422, CR799422 , KBA , BC-SYB-PD , PowerDesigner , Problem

About this page

This is a preview of a SAP Knowledge Base Article. Click more to access the full version on SAP ONE Support launchpad (Login required).

Search for additional results

Visit SAP Support Portal's SAP Notes and KBA Search.