SAP Knowledge Base Article - Preview

2251401 - Support for DB2 z/OS Bi -Temporal Tables - SAP PD

Symptom

We have an application that will be using Bi-Temporal tables in DB2 z/OS Version 10.
Does PD 16.5 support the creation of the DDL for these type tables? Here is a DDL example:

 create table MY_SYSTEM_TIME (
   MY_ID                          CHAR(10)    not null,
   SYS_START        TIMESTAMP(12)      not null     generated always as row begin,
   SYS_END           TIMESTAMP(12)      not null      generated always as row end,
   TS_ID                TIMESTAMP(12)      not null      generated always as transaction start id,
   PERIOD SYSTEM_TIME (sys_start, sys_end)
)  ;

create table HIST_MY_SYSTEM_TIME (
   MY_ID                       CHAR(10)         not null,
   SYS_START        TIMESTAMP(12)        not null,
   SYS_END           TIMESTAMP(12)        not null,
   TS_ID                TIMESTAMP(12)        not null
);

ALTER TABLE my_system_time ADD VERSIONING USE HISTORY TABLE hist_my_system_time;


Read more...

Environment

  • SAP PowerDesigner (PD)

Product

SAP PowerDesigner all versions

Keywords

column, syntax, SQL, 673349, CR673349, CR#673349, 817006, CR817006, CR#817006 , KBA , BC-SYB-PD , PowerDesigner , Product Enhancement

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.