Home Page for the TeradataForum
 

Archives of the TeradataForum

Message Posted: Wed, 23 Oct 2002 @ 14:26:14 GMT


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


Subj:   Re: Does Teradata Support CLOB? Urgent !
 
From:   Dieter N�th

  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.  



But the maximum row length is still 64K, because the row length field in the physical row layout is a word...

James, the only solution is to slice BLOBs in chunks of 64KB. Look at the CLI Developer's kit manual. And on NT there's a VB Blob Sample Application in ...\Teradata Client\blobsamp.

AFAIK BLOBs are announced for V2R5.1, if you want to wait for maybe one year ;-)


Dieter



     
  <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