Chapter 5. Moving XML Data
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 INSERT and 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 ...
Get DB2 now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.
