Results 1 to 3 of 3
  1. #1
    Join Date
    Mar 2007
    Posts
    72

    Unanswered: How can I upload a BLOB or CLOB into a DB2 UDB Column?

    Hi all,
    I have a table define as: col1 int
    col2 BLOB
    col3 TIMESTAMP
    I have several JPEG,GIF, etc photos that I want loaded into this table. I am searching for a shareware tool or sample code that I can use to load the BLOB data. Can anyone recommend a tool or share a free and straight forward SQL code that can do binary large object load.

    Iam working with UDB 8.2 fixpak 14 and soon to go UDBv9.5.

    Any assistance in this problem will be highly appreciated.

    Thanks

  2. #2
    Join Date
    Jan 2007
    Location
    Jena, Germany
    Posts
    2,721
    Have a look here: http://www-128.ibm.com/developerwork...dm-0504stolze/

    I describe a UDF named SI_loadImage() for exactly this purpose.
    Knut Stolze
    IBM DB2 Analytics Accelerator
    IBM Germany Research & Development

  3. #3
    Join Date
    Mar 2007
    Posts
    72
    Thank you very much Knut. That's the kind of thing I was looking for. Now to learning what you did...

    Again thanks

Posting Permissions

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