Home Page for the TeradataForum
 

Archives of the TeradataForum

Message Posted: Wed, 23 Oct 2002 @ 14:01:19 GMT


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


Subj:   Re: Does Teradata Support CLOB? Urgent !
 
From:   Anomy Anom

<-- Anonymously Posted: Wednesday, October 23, 2002 10:00 -->

It is not necessary to set the PermDBSize global parameter to 128K, you can leave this as the default of 64K, and then set each table independently, using the blocksize variable.

For example

CREATE SET TABLE SampDb.PhoneList
,NO FALLBACK
,NO BEFORE JOURNAL
,NO AFTER JOURNAL
,MAXIMUM BLOCKSIZE
(
Number CHAR(10) TITLE 'Number' NOT NULL
)
UNIQUE PRIMARY INDEX( Number );

Will immediately set the blocksize to the maximum allowed, which under V2R4.1 would be 128K.

You can also set the value within the create statement.



     
  <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