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