Results 1 to 4 of 4

Thread: Image in DB2

  1. #1
    Join Date
    Nov 2009
    Posts
    2

    Unanswered: Image in DB2

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

  2. #2
    Join Date
    Jun 2003
    Location
    Toronto, Canada
    Posts
    5,516
    Provided Answers: 1
    Use BLOB datatype
    ---
    "It does not work" is not a valid problem statement.

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

  4. #4
    Join Date
    Jan 2007
    Location
    Jena, Germany
    Posts
    2,721
    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
    Knut Stolze
    IBM DB2 Analytics Accelerator
    IBM Germany Research & Development

Posting Permissions

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