Home Page for the TeradataForum
 

Archives of the TeradataForum

Message Posted: Tue, 02 Jan 2007 @ 20:52:02 GMT


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


Subj:   Re: How to Load CLOB into Teradata
 
From:   Dempsey, Mike

You can use the 'Import' mode of SQL Assistant to load LOBs of up to 10MB.

The actual limit varies depending on the version of SQL Assistant ... and can be overridden if you really want to do that. (and have enough memory on your PC) See the 'Advanced features' section of the help file/user guide if you need to override the limit.

Note that you must set the maximum buffer size on the Export/Import tab of Options, to be large enough to handle the largest LOB you are loading.

Older versions were able to load only BLOBs (not CLOBs) for some DBMSs.

See help file for details of using Import mode.


Mike Dempsey
Teradata Client Tools



     
  <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