Archives of the TeradataForum
Message Posted: Wed, 14 Oct 2009 @ 09:14:25 GMT
I am trying to run the below query . Getting the error '3707: Syntax Error, Expected something like a digit/number'.
If I comment the Partition By line, it works fine. Please help me in this troubleshooting. Thank you.
CREATE MULTISET TABLE output ,NO FALLBACK ,NO BEFORE JOURNAL ,NO AFTER JOURNAL ,CHECKSUM=DEFAULT ( A INTEGER NOT NULL DEFAULT 0, B INTEGER NOT NULL DEFAULT 0 )PRIMARY INDEX(A,B) PARTITION BY RANGE_N ( B BETWEEN 0 AND 9999 EACH 1 ) ;
Thanks n regards,
|Copyright 2016 - All Rights Reserved|
|Last Modified: 27 Dec 2016|