SAP Knowledge Base Article - Preview

2485896 - SAP PD does not generate ALTER INDEX statement to add included column


  • IBM DB2 for z/OS uses the ALTER INDEX statement to include column in index definition.
  • SAP PowerDesigner drops then recreates the index.
  • It should have generated:

ALTER INDEX index-name
   ADD INCLUDE COLUMN (column-name)



  • SAP PowerDesigner (PD) 16.5
  • SAP PowerDesigner (PD) 16.6
  • IBM DB2 for z/OS


SAP PowerDesigner 16.5 ; SAP PowerDesigner 16.6


db2mvs, physical, option, clause, 765508, CR765508, CR#765508, 754475, CR754475, CR#754475 , KBA , BC-SYB-PD , PowerDesigner , Bug Filed

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.