Results 1 to 2 of 2
  1. #1
    Join Date
    Nov 2012
    Zagreb, Croatia

    Unanswered: Load/insert XML file larger than 32k

    we have faced problems in inserting/loading large (larger than 32k) XML files into XML columns.
    My questions:
    1) How to transfer this file to host and achieve this XML file remains unchanged?
    2) Can anyone tell me what is recommended procedure for such large XMLs - using LOAD utility, INSERT statement, using any other tool...?

    Thanks in advance,

  2. #2
    Join Date
    May 2011
    San Jose, CA, USA
    I believe you can load XML values that are greater than 32 KB by using file reference variables in INSERT statements or in the LOAD utility.

    There are some pointers to it in this blog post:

    How to insert XML documents from the file system?

    You might also find examples in this redbook:

    IBM Redbooks | Extremely pureXML in DB2 10 for z/OS

Posting Permissions

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