All Forums Database
anad99 2 posts Joined 06/09
17 Jun 2009
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.

CarlosAL 512 posts Joined 04/08
17 Jun 2009

Here:http://www.teradata.com/teradataforum/Topic15806-10-1.aspxCheers.carlos.

Jim Chapman 449 posts Joined 09/04
17 Jun 2009

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

anad99 2 posts Joined 06/09
18 Jun 2009

Thanks Jim. I will look into this option.Thanks Carlos-It is in spanish. Can you explain the same in English.

Thiru 15 posts Joined 10/08
09 Jul 2009

Use google translate (http://translate.google.com/translate_t#). Input the spanish webpage (http://carlosal.wordpress.com/2008/11/23/insertar-ficheros-de-imagen-en-teradata-usando-windows-scripting-host-y-ado/) and select SPANISH to ENGLISH option..

Thiruppathi Karuppiah

saravanaag 2 posts Joined 12/11
12 Dec 2011

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

NetFx 346 posts Joined 09/06
13 Dec 2011

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.

 

You must sign in to leave a comment.