by Dawn May | Apr 24, 2013 | SQL, Db2 for i, Web
In part one of this two-part blog entry, the idea was introduced that Db2 for i could be integrated with a Web service, using the user-defined functions in the SYSTOOLS schema and the built-in SQL/XML support. Part one includes a number of links to information about the user-defined functions, and also to information on the built-in SQL/XML support. One important resource was a link to a whitepaper that provides the complete details for these functions.
(more…)
by Dawn May | Apr 3, 2013 | Db2 for i, Web
The existence of Web services creates the potential to unite the data from remote sources with the data that is stored locally in a relational database. For customers who have not yet upgraded to the latest technology updates of Db2 for i in 7.1, integrating a Web service with Db2 for i might be complicated. A combination of non-SQL and SQL code is usually needed to send the HTTP request, and also to construct, interpret and process the messages that are exchanged between the client and server. These infrastructure-related details are not what most developers want to spend their time on; the more desirable option is to focus on using the Web service as a tool to understand and process the business data.
(more…)
by Dawn May | May 1, 2012 | SQL, Db2 for i
IBM has included support for the XMLTABLE table function in SQL. XMLTABLE is designed to convert an XML document into a relational result set (rows and columns) using popular XPath expressions. This function has been referred to as the Swiss army knife for working with XML because it can help solve a wide variety of XML related problems.
(more…)
by Dawn May | Mar 29, 2011 | SQL, Db2 for i
If you’ve started using the XML support provided in IBM i 7.1, you may already have tried the exciting feature called “Annotated XML schema decomposition,” which can be used to shred XML data into relational database columns. A recent enhancement of this feature brings more control on how you can decompose XML documents into database tables according to a specified order.
(more…)
by Dawn May | Apr 20, 2010 | SQL
Now that the 7.1 XML enhancements for Db2 for i have been announced, it’s a great time to mention the XML search support that is available in OmniFind V1R2.
(more…)