SAP Knowledge Base Article - Preview

2995720 - History table is created before table index and causes DB2 SQLCode: -540 - SAP PD

Symptom

  • The ALTER TABLE baseTable ADD VERSIONING USE HISTORY TABLE historyTable statement is generated before the CREATE UNIQUE INDEX(Primary index) statement.
  • At execution, DB2 returns SQLCODE=(-540).

THE DEFINITION OF TABLE table-name IS INCOMPLETE BECAUSE IT LACKS A PRIMARY INDEX OR A REQUIRED UNIQUE INDEX

  • The statement cannot be executed. A primary index or a required unique index must be created on the table before referencing it.


Read more...

Environment

  • SAP PowerDesigner (PD) 16.7
  • IBM DB2

Product

SAP PowerDesigner 16.7

Keywords

db2mvs, 823537, CR823537, CR#823537 , 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 ONE Support launchpad (Login required).

Search for additional results

Visit SAP Support Portal's SAP Notes and KBA Search.