Symptom
- When viewing or editing a view's properties, the Data Type column is empty in the Columns tab.
- The view query uses common table expressions (CTE) before a fullselect.
- For example,
WITH expression_name [ ( column_name, ... ) ] AS
( CTE_query_definition )
SELECT column_name, ... FROM expression_name
Read more...
Environment
SAP PowerDesigner (PD) 16.6
Product
SAP PowerDesigner all versions
Keywords
DB2MVS, MSS, Server, 799335, CR799335 , KBA , BC-SYB-PD , PowerDesigner , Problem
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.