SAP Knowledge Base Article - Preview

3434651 - A blank script is generated after modifying the CTE expression of a DB2 view - SAP PD


  • A Common Table Expression (CTE) is specified in a SELECT statement of one view query.
  • When the SQL Query is modified and changes are applied to database, PD generates an empty script instead of the corresponding DROP and CREATE statements.
  • It happens regardless of whether "Always use create statements" or "Use alter statements when possible" is selected.
  • It does not happen when the targeted DBMS is IBM DB2 Version 11 for z/OS.



  • SAP PowerDesigner (PD) 16.7
  • IBM DB2 Version 12 for z/OS


SAP PowerDesigner 16.7


db2mvs, sql, alter, CR829103, CR#829103, 829103, CR804995, CR#804995, 804995 , KBA , BC-SYB-PD , PowerDesigner , Known Error

About this page

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

Search for additional results

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