dilasing

This depends on the data you want to store in the database. The main difference between relational schema and XML schema is that relational schema describes data as strongly structured and typed. XML schema describes data as loosely structured and typed. XML schema describes data order, but relational schema does …

DB2 9 does not support updating an element in XML documents, you must perform a full-document update using the UPDATE SQL statement. UPDATE customer SET info = '<customerinfo xmlns="http://posample.org" Cid="1002"> <name>Jim Noodle</name> <addr country="Canada"> <street>1150 Maple Drive</street> <city>Newtown</city> <prov-state>Ontario</prov-state> <pcode-zip>Z9Z 2P2</pcode-zip> </addr> <phone type="work">905-555-7258</phone> </customerinfo>' WHERE XMLEXISTS ( 'declare default …

This process requires three steps: i)First, you create an XML file using DB2 built-in XML functions. ii)You transform that file using XSL-FO (eXtensible Stylesheet Language - Formatting Objects). Apache xlane might be useful for you. iii)Using an XSL-FO renderer, you transform the file to PDF format. Use apache FOP framework …

Check the query below. I have tested this and it works perfectly. select xmlquery('declare default element namespace "urn:xmlns:bol-listing:business1.0"; $b/businessesname' passing XMLINFO as "b") from testtable where xmlexists('declare default element namespace "urn:xmlns:bol-listing:business1.0"; $b/businessesname' passing XMLINFO as "b") You can find more information at [url]http://www.ibm.com/developerworks/db2/library/techarticle/dm-0611saracco/[/url]

XQuery is a new query language designed specifically to work with XML data. Xquery is a part of the W3C industry standard. It lets users navigate through the hierarchical structure inherent in XML documents. As a result, you can retrieve XML documents or document fragments using XQuery. You can also …

XML Path Language (XPath), one of the most successful XML technologies, is a syntax and data model for addressing parts of an XML document. XPath includes over 100 built-in functions. There are functions for string values, numeric values, date and time comparison, node and QName manipulation, sequence manipulation, Boolean values, …

Hi I am Dilawar Singh from IBM. I noticed some threads listing issues related to XML database management. We have a great product called pureXML, an excellent feature of DB2 9 that provides new data type to store the XML data. Anyone interested in knowing more, or has any questions …