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

• 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.

• SAP PowerDesigner (PD) 16.7
• IBM DB2

db2mvs, 823537, CR823537, CR#823537 , KBA , BC-SYB-PD , PowerDesigner , Known Error