All Forums Database
kuldipkhatri 4 posts Joined 11/08
11 Nov 2008
PPI on varchar or char field: Possible?

Hi,I was wondering if anyone knows whether we can have a varchar/char field as part of PPI or is that PPI can be bult just on numeric fields?

Adeel Chaudhry 773 posts Joined 04/08
12 Nov 2008

Hello,It can also be done on non-numeric fields such as date but "if the data type for the result of partitioning_expression is not INTEGER, then the system implicitly casts the value to the INTEGER type" (taken from Teradata manual), and it cannot be defined on LOB columns.Regards,Adeel

-- If you are stuck at something .... consider it an opportunity to think anew.

You must sign in to leave a comment.