O'Reilly logo

DB2 by Pav Kumar-Chatterjee, Matthias Nicola

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

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 ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required