|
|
Archives of the TeradataForum
Message Posted: Wed, 14 Oct 2009 @ 11:34:52 GMT
Subj: | | Re: Using RANGE_N in Partition By |
|
From: | | Tewksbury, Kevin |
Srikanth,
As others have already posted, there are some extra non-printable characters. I cut and pasted into Linux and then did a :set nu and the
following is what I saw. As you can see there is an extra character after the "0" and "9999", remove these and it works fine.
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 0B AND 9999B EACH 1 ) ;
KRT
| |