Home Page for the TeradataForum
 

Archives of the TeradataForum

Message Posted: Fri, 19 Aug 2011 @ 20:31:56 GMT


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


Subj:   Max Row Size and Data Block Size
 
From:   Gutta_Ram

Hi,

We are using TD 12 and I am trying to create a table with the following ddl. As you can see, datablock size is defined as 130000 bytes, still I am not able to create table with row size > 64000.

Is this a limit on row size itself irrespective of data block size? I don t want to split the table into two and later join in a view Is there any other way of creating this table?

     CREATE MULTISET TABLE table1 ,NO FALLBACK ,
        NO BEFORE JOURNAL,
        NO AFTER JOURNAL,
        FREESPACE = 0 PERCENT,
        CHECKSUM = DEFAULT,
        DATABLOCKSIZE = 130000 BYTES

        (
          Col1 DECIMAL(18,0) NOT NULL,
          C2 VARCHAR(4000) CHARACTER SET UNICODE NOT CASESPECIFIC,
          C3 VARCHAR(4000) CHARACTER SET UNICODE NOT CASESPECIFIC,
          C4 VARCHAR(4000) CHARACTER SET UNICODE NOT CASESPECIFIC,
          C5 VARCHAR(40) CHARACTER SET UNICODE NOT CASESPECIFIC,
          C6 VARCHAR(100) CHARACTER SET UNICODE NOT CASESPECIFIC,
          C7 VARCHAR(100) CHARACTER SET UNICODE NOT CASESPECIFIC,
          C8 VARCHAR(50) CHARACTER SET UNICODE NOT CASESPECIFIC,
          C9 VARCHAR(4000) CHARACTER SET UNICODE NOT CASESPECIFIC,
          C10 VARCHAR(4000) CHARACTER SET UNICODE NOT CASESPECIFIC,
          C11 VARCHAR(4000) CHARACTER SET UNICODE NOT CASESPECIFIC,
          C12 VARCHAR(4000) CHARACTER SET UNICODE NOT CASESPECIFIC,
          C13 VARCHAR(4000) CHARACTER SET UNICODE NOT CASESPECIFIC)

        PRIMARY INDEX ( COL1 );

Thank You



     
  <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: 27 Dec 2016