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.
SAP Knowledge Base Article - Preview