hi, i'm trying to load image to my table which consist of 2 column,
ImageID (varchar) and Image(Blob)
i'm trying to insert it through the DB2 control center but i found no way to do so.
what should i do in order to do the image insertion to the table?by the control center or query statement?

thx before

db/os version?

code you are running?

SQL error you are getting?

Other wise I think you forgot to press that thingy on the left

i'm using db2 9.7 in my windows xp

i was trying to add row, i managed to insert the imageID column as it is a varchar but i found no way to insert the image column that comes in blob data type
is there any way to insert the blob column with open table or query statement?
the image file is located in my desktop directory

Look into /sqllib/samples/java/jdbc>more DtLob.java

there are samples there. plus google has many hits on "insert image into db2"

Another option is to use the IMPORT command - check out the LOBS FROM option.

could you show me steps to do it?


anyway, i hope if there is anyway to do query than makin java program to store the picture?

n_i and cougar8000 have given you hints ...
Anything more, probably you need to hire someone

Certainly.

1. Open DB2 Information Centre at DB2 Database for Linux, UNIX, and Windows

2. Search for "import command".

3. Read.

4. ???

5. Profit.

You can also read here. I UDF (user-defined function) is shown to import files residing on the database server machine: A DB2 UDB still image extender