Symptom
- Multiple columns are included to a DB2 index.
- Applying Model Changes to the database fails, PD generates the following incorrect SQL statement:
ALTER INDEX index-name
ADD INCLUDE COLUMN (list of columns); - It should generate a separate ALTER statement for each column:
ALTER INDEX index-name
ADD INCLUDE COLUMN (column-name);
Read more...
Environment
- SAP PowerDesigner (PD) 16.7 SP06
- IBM DB2 Version 12 for z/OS DBMS
Product
SAP PowerDesigner 16.7
Keywords
db2mvs, CR827539, CR#827539, 827539 , 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.
SAP Knowledge Base Article - Preview