Results 1 to 2 of 2
  1. #1
    Join Date
    Sep 2008

    Unanswered: Exporting the complete contents of CLOB/BLOB fileds

    I would like to export the whole content of a clob field. When I run the query

    db2 "export to temp.del select char(substr(exceptiontree, 1, 100)) as clob from db2sch.logging where date(datestamp)='2008-09-30' and exceptiontree is not null"

    It exports the data. However, obviously only 100 bytes.

    However, if I change the size of substr to 500, I get the SQL0433N message that the value is too long

    What I would like is to export the complete contents of the exceptiontree filed, is there a way of doing this?

  2. #2
    Join Date
    Jun 2003
    Toronto, Canada
    Provided Answers: 1
    Use the LOBSINFILE modifier.
    "It does not work" is not a valid problem statement.

Posting Permissions

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