Home Page for the TeradataForum

Archives of the TeradataForum

Message Posted: Thu, 23 Jun 2005 @ 14:18:19 GMT

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

Subj:   Re: Updating a CLOB column
From:   Dempsey, Mike

In general I think Teradata assumes that when you want to load very large LOBs you will have a custom application to process them. (Movies, X- Rays, etc.)


You can load LOBs larger than 1MB with SQL Assistant as follows:

Go to the following registry entry:


Change the value of 'ImportBuf' to the maximum size of your LOBs. (about 1600000000 in this case)

Do NOT change any preferences/options within SQLA before loading your LOBs. (The next time you change ANY SQLA option the import buffer size will be truncated to the first 6 'characters' of the size you specified. If you specified 1600000000 in the registry it will be reset to 160000 after the option change.)

I have tested this with a 3MB file (greater than the 'normal' SQLA limit) but never with anything of the size you are trying.

WARNING: SQLA will try to read the entire file into memory at one time and pass this buffer to ODBC... so this will only work if you happen to have 2GB memory on your PC (Theoretically that could be 2GB of virtual memory I guess) and if the ODBC driver can handle a 1.6GB buffer.

It wouldn't hurt to try I guess.

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: 15 Jun 2023