Results 1 to 2 of 2
  1. #1
    Join Date
    Jun 2010
    Posts
    15

    Unanswered: Exporting large amounts of CLOB data

    I have a table with two fields, id and XML. The XML field is a CLOB type.

    When I try to export some data to a text file

    Code:
    db2 SELECT * FROM XMLREULTS where id='198.8192.123'
    I open the text file that is created and I see the XML. However, about halfway through, I see:

    DB29320W Output has been truncated.



    1 record(s) selected.

    How can I get the full result to export?

  2. #2
    Join Date
    May 2003
    Location
    USA
    Posts
    5,737
    The export row is truncated at 32K unless you specify that LOBs be stored in a seperate file.

    db2 export to myfile.del of del lobs to /db2exp1/ modified by lobsinfile select * from emp_photo

    The above example also specifies the path where the lob files will go (or you can use the current path).
    M. A. Feldman
    IBM Certified DBA on DB2 for Linux, UNIX, and Windows
    IBM Certified DBA on DB2 for z/OS and OS/390

Posting Permissions

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