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

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