Symptom
- 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.
Read more...
Environment
- SAP PowerDesigner (PD) 16.7
- IBM DB2 Version 12 for z/OS
Product
SAP PowerDesigner 16.7
Keywords
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.