DB2- Insert image?

Madhana Kumar · #1 (**permalink**) 11-12-09, 18:02

Hello Everyone,
I am new to DB2.
I created a table in a GUI in DB2 9 with two fields,
one is integer and other BLOB.
I can type value for INTEGER but how to insert image into database now?
I want to do this without any commands.
Is it possible? If so how/
Plz help me out.

sawangupta · #2 (**permalink**) 11-13-09, 00:14

How about a simple CLI application and using SQLBindFileToCol API

SQLBindFileToCol - IBM DB2 9.7 for Linux, UNIX, and Windows

Regards,
Sawan Gupta

Madhana Kumar · #3 (**permalink**) 11-13-09, 00:49

Thats interesting.
Thank You very much.
But is there a easy way to do this without typing any commands?
I created database and entered the values without using CREATE & INSERT. Instead I used DB2 Control Center to do this in a easy fashion.
Like this can I insert a image without breaking a sweat in DB2?

sathyaram_s · #4 (**permalink**) 11-13-09, 01:37

Quote:

Originally Posted by Madhana Kumar

Like this can I insert a image without breaking a sweat in DB2?

Internet Services

Web Development

Digital Marketing

Consumer Tech