IBM I 7.1

© 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/091357456
5/27/092468123
Purchase
Order
DateCustomer #PO #
~
XML
~
~
XML
~