Hi all,
I have a table define as: col1 int
col2 BLOB
col3 TIMESTAMP
I have several JPEG,GIF, etc photos that I want loaded into this table. I am searching for a shareware tool or sample code that I can use to load the BLOB data. Can anyone recommend a tool or share a free and straight forward SQL code that can do binary large object load.

Iam working with UDB 8.2 fixpak 14 and soon to go UDBv9.5.

Any assistance in this problem will be highly appreciated.

Thanks

Have a look here: http://www-128.ibm.com/developerwork...dm-0504stolze/

I describe a UDF named SI_loadImage() for exactly this purpose.

Thank you very much Knut. That's the kind of thing I was looking for. Now to learning what you did...

Again thanks