Image in DB2

sumanjoshi.28 · #1 (**permalink**) 11-25-09, 00:43

Hi... I am using IBM DB2 Veersion 9.
How to sotre image in this database.

n_i · #2 (**permalink**) 11-25-09, 07:20

Use BLOB datatype

sumanjoshi.28 · #3 (**permalink**) 11-25-09, 08:06

hi..
yup.. i used BLOG data type.... I am trying to add rows through GUI... i have one Integer datatype and one BLOG data type in my table... so i am not getting how to insert integer value and image file to that table...
plz. help.

stolze · #4 (**permalink**) 11-25-09, 09:05

You need some functionality that reads the data from the file and passes it to the BLOB (not BLOG). Depending on what your GUI is, you may already have such a feature, or you may need some function for that. It also depends on the answer to the question where the file resides - is it on the database server or the local client? If it is on the server, you could do something like this: A DB2 UDB still image extender

Internet Services

Web Development

Digital Marketing

Consumer Tech