Archives of the TeradataForum

Message Posted: Wed, 14 Oct 2009 @ 11:34:52 GMT

	<Prev	Next>		<<First	<Prev	Next>	Last>>

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

	<Prev	Next>		<<First	<Prev	Next>	Last>>