Symptom
- The SQL Query of a view contains a Common Table Expression (CTE) in a DB2 Physical Data Model (PDM).
- Upon clicking Apply/OK or another tab in the properties window, the FROM clause shifts to the right.
- The desired SQL script layout cannot be preserved as intended.
- This issue occurs regardless of whether the 'User-defined' option is selected or not.
Read more...
Environment
- SAP PowerDesigner (PD) 16.7
- IBM DB2 Version 12 for z/OS
Product
SAP PowerDesigner 16.7
Keywords
PowerDesigner, SQL Query, View Object, Common Table Expressions, CTE, DB2 PDM, User-defined, Shift, Layout. , 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.