|
Archives of the TeradataForumMessage Posted: Mon, 23 Jul 2012 @ 08:14:01 GMT
<-- Anonymously Posted: Sunday, July 22, 2012 11:57 --> Hi all, I want to create a set table with PPI index on Timestamp(0) type column But every time I am getting the error no. 3732 Is it possible to create PPI on the Timestamp column? The query is as follows:-- CREATE VOLATILE MULTISET TABLE TEST_TRNS_DT ( ACC_KEY INTEGER ,TRNS_TYPE CHAR(5) ,TRNS_DATE TIMESTAMP(0) NOT NULL ) unique PRIMARY INDEX(TRNS_DATE) PARTITION BY RANGE_N(TRNS_DATE BETWEEN TIMESTAMP '2012-07-23 00:19:07' AND TIMESTAMP '2012-10-23 00:19:20' EACH INTERVAL '1' SECOND); Pls help me to correct my query to create table with PPI based on TIMESTAMP(0) column With Thanks in Advance
| ||||||||||||||||||||||||||||||||||||||||||||||||
| ||||||||||||||||||||||||||||||||||||||||||||||||
Copyright 2016 - All Rights Reserved | ||||||||||||||||||||||||||||||||||||||||||||||||
Last Modified: 15 Jun 2023 | ||||||||||||||||||||||||||||||||||||||||||||||||