Insert blobs
Hello all.
I am using DB2 UDB 7 and I need insert a lot of pictures in a database.
But unfortunality i could not do that.
I have a table with 2 rows , one is BLOB to storage a picture.
I follow the manual but I not find any reference to how I can do that.
Please, Can anybody kindly help me or tell me where I can find a reference
to insert a Blob dataype in a Db2?
I am using Visual Age to create my interface, but I need write the sql state
( insert into...)
Tanks a lot .
Jose Venancio Finger Neto.
# 1 Re: Insert blobs
Hi,
As far as i know, that's no way u can insert an object (picture file) into
the database using the SQL statment. U can insert them only thru the wizard
provided by DB2 UDB 7.
This is what i got from my trainer during the DB2 course training. If
you do find out a way to insert the picture file using a script / sql statement,
please kindly email me at jennysll@yahoo.com.
Regards,
Jennifer
"Jose Finger" <finger@midiaweb.com.br> wrote:
>
>Hello all.
>I am using DB2 UDB 7 and I need insert a lot of pictures in a database.
>But unfortunality i could not do that.
>I have a table with 2 rows , one is BLOB to storage a picture.
>I follow the manual but I not find any reference to how I can do that.
>Please, Can anybody kindly help me or tell me where I can find a reference
>to insert a Blob dataype in a Db2?
>I am using Visual Age to create my interface, but I need write the sql state
>( insert into...)
>Tanks a lot .
>Jose Venancio Finger Neto.
>