Storing images/PDF/.. in BLOB

Database
Fan

Storing images/PDF/.. in BLOB

How to insert images/PDFs/Files into BLOB data type? Is it thru UDF or some other means. Please provide steps.
6 REPLIES
Junior Supporter

Re: Storing images/PDF/.. in BLOB

Here:

http://www.teradata.com/teradataforum/Topic15806-10-1.aspx

Cheers.

carlos.
Enthusiast

Re: Storing images/PDF/.. in BLOB

Another option (with Teradata/TTU 12.0 and later) is BTEQ. Take a look at the LOBCOLS option in the import statement.
Fan

Re: Storing images/PDF/.. in BLOB

Thanks Jim. I will look into this option.

Thanks Carlos-It is in spanish. Can you explain the same in English.
Enthusiast

Re: Storing images/PDF/.. in BLOB

Re: Storing images/PDF/.. in BLOB

Hi,

Could you explain how to insert an image on a table from SQL Assitant?

My_Table (ID Char(10,Image_File BLOB)

Thanks for your help!!

Teradata Employee

Re: Storing images/PDF/.. in BLOB

See "Importing Data" section in the SQL Assistant Help File. SQLA supports ?B and ?C parameter markers for BLOB and CLOB import data.

?B - The data for this parameter resides in a file that is in the same directory as the Import file. The import file contains only the name of the file to be imported. The contents of the file are loaded as a binary image.

?C - The data for this parameter resides in a file that is in the same directory as the import file. The import file contains only the name of the file to be imported. Use this marker to load a text file into a CHAR or CLOB column.