Results 1 to 4 of 4
  1. #1
    Join Date
    Nov 2009
    Posts
    5

    Question Unanswered: DB2- Insert image?

    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.

  2. #2
    Join Date
    Nov 2009
    Location
    Bangalore
    Posts
    25
    How about a simple CLI application and using SQLBindFileToCol API

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

    Regards,
    Sawan Gupta

  3. #3
    Join Date
    Nov 2009
    Posts
    5
    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?

  4. #4
    Join Date
    Aug 2001
    Location
    UK
    Posts
    4,650
    Quote Originally Posted by Madhana Kumar View Post
    Like this can I insert a image without breaking a sweat in DB2?
    Visit the new-look IDUG Website , register to gain access to the excellent content.

Tags for this Thread

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •