SAP Knowledge Base Article - Preview

3546683 - Unexpected shift when modifying the SQL query of DB2 views with CTE expression - SAP PD

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.