To row partition a transaction-time table, use the following PARTITION BY clause.
Example: Row partitioning a trasaction-time table
CREATE MULTISET TABLE Policy_Types ( Policy_Name VARCHAR(20), Policy_Type CHAR(2) NOT NULL PRIMARY KEY, Policy_Duration PERIOD(TIMESTAMP(6) WITH TIME ZONE) NOT NULL AS TRANSACTIONTIME ) PRIMARY INDEX (Policy_Name) PARTITION BY CASE_N (END(Policy_Duration) >= CURRENT_TIMESTAMP, NO CASE);