With V5R1 comes new XML enhancements to IBM's DB2 Universal Database (UDB), designed to ease business-to-business (B2B) transactions (Part 1 Insider Weekly, 3/19/01).
Further enhancements to DB2 UDB:
* DB2 for iSeries XML Extender. eXtensible Markup Language (XML), is an open standard for describing data and is used for defining data elements on a Web page and B2B documents.
The XML Extender, available separately from IBM, lets users take an XML document, pass it into the database, and break it up into columns and tables, decomposing the XML document. This process also works in reverse, making the extender perfect for B2B trade.
* New Text-Extenders perform searches within the database. The text search engine uses character objects within the database. Users can search based on a proximity of words, synonyms, etc.
* Two-Phased Commit over TCP/IP. The ability to perform Two-Phased Commit allows customers to simultaneously update multiple databases running on separate platforms. Previously, DB2/400 was only over Advanced Program to Program Communication (APPC). Enhanced to support TCP/IP, iSeries shops can now have transactions open on multiple databases.
What it means: This opens the door to iSeries customers, allowing them to be a player in large distributed systems with SQL.
* Stored Procedure Result Set Support. Users can now run a query and have a client fetch the results from Stored Procedure. There can be an array of rows created in Stored Procedure and a user can do different operations with a set of input values and have Stored Procedure return result sets. This is important in a client-server environment, where stored procedures are typically used.
What it means: Stored Procedure eliminates the need to write SQL statements on the PC side, lessens the amount of code on the PC, and helps to distribute work load.
* Right-join capabilities. A join is the capability to query data from multiple tables using a single SQL statement. Right outer join causes DB2 to return rows with matching values in the predicate columns, but also to return unmatched rows from the table on the right side of the join.
What it means: Although most platforms have the capability to do a right outer join, this is the first time it is available for DB2/400. This capability will improve the portability of applications.