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

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.