Symptom
- Views which query uses a common table expression (CTE) should be dropped and created again when the underlying table has been recreated.
- SAP PowerDesigner only drops then recreates the table.
- If the view has not been created with a CTE, it drops the view and the table, then recreates the table and the view.
Read more...
Environment
- SAP PowerDesigner (PD) 16.6 SP02
- IBM DB2 Version 11 for z/OS
Product
SAP PowerDesigner all versions
Keywords
db2mvs, associated, sql, 804995, CR804995, CR#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.