DB2 importing/replacing fields from a file that contains XML In two tables I have a column called table1.column_xml and table2.column_xml_2 defined as CLOB(1000000). The fields in the column contain XML formatted information like below

column_xml                                                                       
--------------------------------------------------------------------------------
&lt;values&gt;                                                                      
 &lt;comment&gt;test test test&lt;/comment&gt;
 &lt;rights&gt;&lt;/rights&gt;                                                            
 &lt;title&gt;TEST MAN&lt;/title&gt;                                         
&lt;/values&gt;                                                                     
--------------------------------------------------------------------------------


What I would like to do is import/or replace any existing values in table2.column_xml_2 with the values from table1.column_xml.

So in simpler terms I want to export the values from column_xml into a file then import/replace into column_xml_2
Why don't you just 

update table2 set column_xml2 = 
(select column_xml from table1 where &lt;predicate clause&gt;) where &lt;predicate clause&gt;;


?

With CLOBs you pretty much have to do that. You can only update the entire CLOB. Now if are on DB2 9.1 or higher, you could store these in a field of type XML and then you could attempt to update specific XML elements like how you are hoping to do.