SAP Knowledge Base Article - Preview

2374813 - DB2 index is renamed without a schema name - SAP PD

Symptom

  • SAP PowerDesigner uses the RENAME statement to rename an existing index, but the generated syntax misses the schema name.
  • The source-index-name should include an implicit or explicit qualifier.
    The new-index-identifier specifies new name for the index without a qualifier.
  • It generates:   

rename index INDEX_OLD to INDEX_NEW;

  • instead of:

rename index SCHEMA.INDEX_OLD to INDEX_NEW;

"Image/data in this KBA is from SAP internal systems, sample data, or demo systems. Any resemblance to real data is purely coincidental."


Read more...

Environment

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

Product

SAP PowerDesigner 16.6

Keywords

db2mvs, user, alter, altered, modify, modified, change, changed, 802690, CR802690, CR#802690 , 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.