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 for Me (Login required).

Search for additional results

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