SAP Knowledge Base Article - Preview

3285875 - Only one ALTER statement is generated although several columns are included to a DD2 index - SAP PD

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.