Archives of the TeradataForum

Message Posted: Wed, 14 Oct 2009 @ 10:18:51 GMT

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

Hi Srikanth,

The exact syntax works for me very well. But the syntax copied from your mail and executed, is giving the same error as you are saying. Not sure if there any extra characters in your syntax.

Now copy this text and try, it should work.

     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 ) ;

Regards,

Hemanth.

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