Save BLOB content as a File... BTEQ / SP

Database

Save BLOB content as a File... BTEQ / SP

A BLOB column has a xyx.ZIP file. I need a BTEQ to pull out ALL these files from the BLOB column and SAVE them as '.ZIP' FILES at 'SPECIFIED PATH'.

".EXPORT" doest not work on LOBs. Also, Would CAST ing the column to VARBYTE help.

Any suggestions ???
1 REPLY
Junior Supporter

Re: Save BLOB content as a File... BTEQ / SP

If in windows, you could try an ADO/OLEDB/WSH/VBS solution like I did here:

http://carlosal.wordpress.com/2010/01/26/guardar-datos-de-columnas-blob-en-teradata-como-ficheros-usando-windows-scripting-host-y-oledbado/

HTH.

Cheers.

Carlos