More detail from our L3 for LMi below. Pls run it through support if this doesn't get you past the finish line.
Best,
d
~~
Linda 7/29 via slack...
...minimum LMi 8.5 and V7R3.
first add history *TABLE.
then checkout and convert *FILE to *TABLE with option 16.
then option 16 again to convert *TABLE to temporal table...
there are other details but seems they lend themselves more to a support call...
things like moving source from QDDSSRC to QSQLSRC (if they choose to do so), change member source type from PF to SQL, etc...
------------------------------
Dale
L3 Support for the enterprise bits, portals and plugins...
Rocket|Aldon
Somewhere on the Oregon coast...
------------------------------
Original Message:
Sent: 07-29-2021 17:23
From: Dale Asher
Subject: How to change physical file (DDS) to become a temporal table using Aldon?
Ramiro,
Quick summary would require checkout, option 16 to change to table, then F6 to add history table. We'll run a quick local test to see if there are any other highlights and confirm earliest LMi version (suspect it's 8.5) that would support temporal tables.
Best,
d
------------------------------
Dale Asher
Rocket Internal - All Brands
Original Message:
Sent: 07-28-2021 13:00
From: Ramiro Blanco
Subject: How to change physical file (DDS) to become a temporal table using Aldon?
Is it possible to change physical file definition (DDS) using Aldon to become a temporal table?
Need to add the following columns to the physical file:
ADD COLUMN TEMPORAL_ROW_START TIMESTAMP(12) IMPLICITLY HIDDEN NOT NULL GENERATED ALWAYS AS ROW BEGIN
ADD COLUMN TEMPORAL_ROW_END TIMESTAMP(12) IMPLICITLY HIDDEN NOT NULL GENERATED ALWAYS AS ROW END
ADD COLUMN TEMPORAL_ROW_TRANS TIMESTAMP(12) IMPLICITLY HIDDEN NOT NULL GENERATED ALWAYS AS TRANSACTION START ID
ADD COLUMN TEMPORAL_audit_user VARCHAR(128) GENERATED ALWAYS AS (SESSION_USER)
ADD COLUMN TEMPORAL_audit_op CHAR(1) GENERATED ALWAYS AS (DATA CHANGE OPERATION)
ADD PERIOD SYSTEM_TIME(TEMPORAL_ROW_START, TEMPORAL_ROW_END
Also, need to create the history table and associate it to the physical (temporal) table:
CREATE TABLE library.physicalfilename_history;
ALTER TABLE library.physicalfilename
ADD VERSIONING USE HISTORY TABLE library.physicalfilename_history ON DELETE ADD EXTRA ROW;
------------------------------
Ramiro Blanco
r_blanco@attglobal.net
Self Registered
Lake Worth FL United States
------------------------------