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