Archives of the TeradataForum

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

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

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.)

Unofficially...

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

Go to the following registry entry:

     HKEY_CURRENT_USER\Software\NCR\Queryman

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>>