0 - 2 of 2 tags for validtime

CREATE MULTISET TABLE XXX.electronicaddress ,NO FALLBACK ,

     NO BEFORE JOURNAL,

     NO AFTER JOURNAL,

     CHECKSUM = DEFAULT,

     DEFAULT MERGEBLOCKRATIO

     (

      AddressId VARCHAR(100) CHARACTER SET LATIN NOT CASESPECIFIC NOT NULL,

Hello,

I have a view that references a temporal table, i.e.

 

CREATE MULTISET TABLE P_SMA_T.myTable
(
    EffectivePeriod PERIOD(DATE) AS VALIDTIME
    ...
);

CREATE VIEW P_SMA.vt_myTable
AS
SELECT EffectivePeriod
    ...
FROM P_SMA_T.myTable;