Load/Unload XML data in DB2

If XML data in the table is less than 32K for each record, then you can directly unload the data as char.

If XML data exceeds 32K for some records, then you have to unload the common data and the XML data separately.

First, create a template for unloading XML into a PDS:

TEMPLATE LOBFRV DSN 'AAA.BBB.LOB' DSNTYPE(PDS)

Then unload XML data using the template:

XMLDATA VARCHAR(12345) CLOBF LOBFRV

To load XML data from PDS, use “CLOBF” keyword to indicate that the column will be loaded from file, and POSITION(122:150) indicates the file name location in the record file.

XMLDATA POSITION(122:150) CHAR CLOBF