SAP Knowledge Base Article - Preview

2895778 - Reverse engineer for db2 z/os 11 temporal table got wrong syntax - SAP PD

Symptom

  • When run reverse engineer from live database, it generates the following wrong code:

SYS_START_TMSTMP TIMESTAMP(12)
not null with default,
SYS_END_TMSTMP TIMESTAMP(12)
not null with default,
TRANS_TMSTMP TIMESTAMP(12) with default,
PERIOD SYSTEM_TIME (SYS_START_TMSTMP, SYS_END_TMSTMP)

  • The correct code should be:

SYS_START_TMSTMP TIMESTAMP(12) NOT NULL GENERATED ALWAYS AS ROW
BEGIN
,SYS_END_TMSTMP TIMESTAMP(12) NOT NULL GENERATED ALWAYS AS ROW END
,TRANS_TMSTMP TIMESTAMP(12) GENERATED ALWAYS AS TRANSACTION START ID
,PERIOD SYSTEM_TIME(SYS_START_TMSTMP, SYS_END_TMSTMP)


Read more...

Environment

SAP PowerDesigner (PD) 16.6 SP10

Product

SAP PowerDesigner 16.6

Keywords

DB2 Z/OS, Temporary table, Reverse engineer, 820861, CR820861, CR#820861 , 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 ONE Support launchpad (Login required).

Search for additional results

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