Results 1 to 4 of 4

Thread: Large Files

  1. #1
    Join Date
    Jan 2009
    Posts
    153

    Unanswered: Large Files

    Hi Experts,

    How can i stored large files in a table?

    I am having more than 200 XSD & XLS files.

    Please help

    TIA

  2. #2
    Join Date
    Jan 2007
    Location
    Jena, Germany
    Posts
    2,721
    You create the table with a column of type XML, CLOB, or BLOB (whatever suits you best) and then insert the data in this column.
    Knut Stolze
    IBM DB2 Analytics Accelerator
    IBM Germany Research & Development

  3. #3
    Join Date
    Jan 2009
    Posts
    153
    Thanks Stolze,
    How can i insert a file in a column?

    Can you give me an example?

    TIA

  4. #4
    Join Date
    Jan 2007
    Location
    Jena, Germany
    Posts
    2,721
    You read the file into a variable in your program and then insert the variable in the table. Alternatively, if the file happens to reside on the database server, you can use a UDF as I did in this article for similar purposes to load images into a BLOB column: 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
  •