Db2 for i – xml support – IBM I 7.1 User Manual
Page 10

© 2010 IBM Corporation
IBM Power Systems
10
DB2 for i – XML Support
XML is an industry standard for exchanging
information between customers, suppliers,
and partners
Rich XML Support now available with DB2 for i
1.
XML data type stores XML documents supporting database operations
2.
Decompose (shred) XML documents into relational columns
3.
Generate XML documents from existing relational data
OmniFind Text Search Server provides
support for searching XML documents
–
Search elements of an XML document (e.g., customer name = Smith)
–
SQL statements use OmniFind to search the XML documents
–
Available with IBM i for no additional charge
Strategic replacement for XML Extenders
Program Product
6/10/09
1357
456
5/27/09
2468
123
Purchase
Order
Date
Customer #
PO #
~
XML
~
~
XML
~