I am getting the following error while using the following query:
How do I get rid of this error?
Following should work:
CREATE MULTISET TABLE Policy(
Policy_Type CHAR(2) NOT NULL,
Validity PERIOD(DATE) AS VALIDTIME
CURRENT VALIDTIME SELECT * FROM Policy;
Added 'AS VALIDTIME' and 'MULTISET'.