Home Page for the TeradataForum
 

Archives of the TeradataForum

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


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


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



     
  <Prev Next>   <<First <Prev
Next>
Last>>
 
 
 
 
 
 
 
 
 
  
  Top Home Privacy Feedback  
 
 
Copyright for the TeradataForum (TDATA-L), Manta BlueSky    
Copyright 2016 - All Rights Reserved    
Last Modified: 15 Jun 2023