hi,

i want to store images ina db2 table, can anyone give me table structre and insert/select statment for this

thanks

Hi,

I think you can use a clob to do it.

The table structure can be like this

IMAGE_MASTER(
IMAGE_NAME VARCHAR(10),
IMAGE_URL VARCHAR(255),
IMAGE CLOB(2 M) NOT LOGGED NOT COMPACT)

Please check for the datatypes in the db2 documentation for better guidance.

Use BLOB, not CLOB, otherwise you'll get codepage conversion, which is very undesirable for bytes in an image!

But the most interesting question remains!
- how di you actually tell db2 to store a file
in the CLOB or BLOB columns, i.e. which syntax
would you use to insert a picture residing on the
same server as the database??

Cheers

See the samples/java/jdbc/DtLob.java or samples/c/dtlob.sqc

They actually use this exact example, inserting a picture, so it should be pretty easy from there.