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 4. Inserting and Retrieving XML Data

In this chapter we discuss “full document” operations, such as insert, delete, and retrieval of whole XML documents in DB2 tables. These are the most basic and most common operations for XML documents. Insert and retrieval operations are of particular interest. They involve the conversion of textual XML data to DB2’s internal XML format upon insert, and the reverse upon retrieval. This conversion from and to the character representation of XML requires handling of XML declarations, whitespace, and reserved characters. DB2 handles these matters automatically for you, but some options exist that allow you to customize its behavior if needed.

In this chapter you learn

• How to insert XML documents ...

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