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.