BTEQ script to load BLOB (images) into Teradata

UDA

BTEQ script to load BLOB (images) into Teradata

Can someone please provide a good example of a BTEQ script to load images into a BLOB field.

thanks
1 REPLY
Enthusiast

Re: BTEQ script to load BLOB (images) into Teradata

I think you need the new, upcoming version of BTEQ that can handle LOBs (due in V12 adn V13 in Oct.?). The syntax would be something like this:

.using '/yourfolder/yourblobfile'
using (yourIMG BLOB as deferred)
insert into dbname.tablename values (:yourIMG)