PPI - Global Temporary Table

Database
Enthusiast

PPI - Global Temporary Table


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.

Thanks,
Manu.
7 REPLIES
Enthusiast

Re: PPI - Global Temporary Table

hi,
I work with Teradata V2R6 and it is possible to have PPI for Global Temporary
Tables.

Rgds,
Aravind
Enthusiast

Re: PPI - Global Temporary Table

I am using Teradata V2R6. Still i am getting the error. Can any one please provide me an executable Global temporary table script with PPI so that i can check at my end.
Enthusiast

Re: PPI - Global Temporary Table

Hi Manu,
The DDL you have posted works fine on V2R6..
check ur version once again...

Enthusiast

Re: PPI - Global Temporary Table

The Version I am Using is "06.00.02.10" .

Is it not supported in this??
Enthusiast

Re: PPI - Global Temporary Table

The Version I am Using is "06.00.02.10" .

Is it not supported in this??
Enthusiast

Re: PPI - Global Temporary Table

The Version I am Using is "06.00.02.10" .

Is it not supported in this??
Enthusiast

Re: PPI - Global Temporary Table

Hi Manu,
I am using Teradata V2R6( version 06.01.01.11).
If you are in any Teradata customer site,I suggest you to contact Teradata global consulting centre.