By going through the Teradata docs i was able to see like
"The primary index for a global temporary table can be either an NPPI or a PPI" but when i am executing the script,
CREATE GLOBAL TEMPORARY TABLE TAB03 ( TAB03_COLA INTEGER NOT NULL, TAB03_COLB INTEGER NOT NULL, TAB03_COLC DATE FORMAT 'yyyy-mm-dd' NOT NULL )UNIQUE PRIMARY INDEX (TAB03_COLA, TAB03_COLB, TAB03_COLC) PARTITION BY RANGE_N(TAB03_COLC BETWEEN DATE '2003-01-01' AND DATE '2003-05-31' EACH INTERVAL '1' DAY);
is is giving the error "5711: PARTITION BY is not allowed. "
When i see the Message Guide ... 5711 PARTITION BY is not allowed. Explanation: A partitioned primary index is not allowed to be specified for a global temporary table,volatile table, join index, or hash index.
So Which is correct?
Can anyone please help me out? Can i conclude PPI is not supported for Global Temporary Table.