Partition In Global Temp

UDA

Partition In Global Temp

I tried to create a partition in global temporary. And I came across with an error "Partition is not allowed". Does any one know what version of Terradata supporting for partition in global Temp? What kind of upgrade should I do? (Hardware or software). Thank you for the help.
And here is my table code

CREATE MULTISET GLOBAL TEMPORARY TABLE Database_XX.Mytable_test
(

clm_key DECIMAL(18, 0) NOT NULL
, fnl_clm_cd CHAR(2) NOT NULL COMPRESS '02'
, pd_dt date NOT NULL
)
PRIMARY INDEX (clm_key)
PARTITION BY RANGE_N(PD_DT BETWEEN DATE '1997-01-01' AND DATE '2010-12-31' EACH INTERVAL '1' MONTH ,
NO RANGE, UNKNOWN)
ON COMMIT PRESERVE ROWS
1 REPLY
Enthusiast

Re: Partition In Global Temp

Support for partitioned volatile and global temporary tables was implemented in version V2R6.1. I tried your SQL statement on my V2R6.1 system, and it executed successfully.