This chapter looks at the different methods for moving large numbers of XML documents into and out of the database. We also discuss moving XML data between databases with federation and replication. These concepts apply to both DB2 for z/OS and DB2 for Linux, UNIX, and Windows.
You can perform basic insert and retrieval of XML documents with SQL
SELECT statements. However, for bulk processing of XML documents it is often more convenient and more efficient to use the
LOAD utility, which is available on all platforms, or the
IMPORT utility in DB2 for Linux, UNIX, and Windows. The tradeoff between insert, load, and import is the same as for relational data. Some applications might have to issue an ...