Archives of the TeradataForum

Message Posted: Fri, 24 Feb 2006 @ 18:27:25 GMT

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

If you are using SQL Assistant you can do it with the import option.

Your INSERT statement will look something like this:

     INSERT INTO myTable
     ( myIndexcol,
       myBLOBcol
     )
     VALUES
     ( ?, ?? );

Where your input file contains two values on each line. The Index value for the primary index column and the name of the file where the BLOB resides. This file must be in the same directory as the import file.

Note if the blob you wish to import a BLOB larger than 10MB you will need to do the following steps:

Warning: SQL Assistant will attempt to allocate this amount of memory for each LOB column in your import query. If your workstation does not have enough free memory the application will fail.

Note: This is not an efficient way of loading large LOBs. If you have a need to load many such LOBs it would be far better to use a custom application written using the Teradata Call Level Interface (CLI), or other vendor equivalent.

Note: This will be a temporary change. The next time you click OK on the Options screen the value will be reset to the first 7 digits of the number you had set. (for example, 65MB will become 6.5MB.)

---------------------------------------------------------------

To enable importing of files larger than 10MB into BLOB or CLOB columns:

Method 1

Select Tools > Options, then select the Export/Import tab.

Select the Import tab.

Click in the Maximum Size of an Imported data file field.

Press the Esc key, then set the value to the size of the largest file you wish to load, up to a maximum of 9 digits.

If you do not press the Esc key before entering the data, you will be limited to a maximum of 7 digits in this field.

Click OK.

---------------------------------------------------------------

To enable importing of files larger than 10MB into BLOB or CLOB columns:

Method 2

Edit the registry key HKEY_CURRENT_USER\Software\NCR\Queryman.

Add or modify the string value ImportBuf, setting its value to the size of the largest file you wish to load.

Ed Ray
Senior Data Warehouse Consultant
Teradata Government Systems
Professional Services
Teradata Certified Master

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