(Philip Howard) The next release of IBM’s DB2 (for both z series and distributed systems), which is code-named ‘Viper’, will be generally available in the not too distant future: “mid-summer” for distributed systems, according to IBM. It is therefore appropriate to consider some of the new features

(Dimple Bhatia, Qinglong (Peter) Hu and Hans Zeller) WebSphere Federation Server (previously named WebSphere Information Integrator) uses "nicknames" to federate access to data sets on remote data sources. Nicknames act as local proxies to the remote tables or table-like data sets. The Resources s

(Susana Schwartz) After battling incomplete or inaccessible data that slowed product launches and affected customer service, Panasonic and Bell Canada Enterprises took control of their vital information with targeted master data management solutions. Today, they have a single system of record, witho

(Robert Brunner) In the previous article in this series, “Database development with Apache Derby, Part 2: Schemas,” you executed SQL commands directly at the prompt of the ij tool. By using the ij tool, you can easily experiment with different SQL or Derby commands. Often, however, you’ll need to ex

(Barbara Darrow) SAP is slated to anoint IBM’s upcoming DB2 database, code-named Viper, as the “preferred and recommended” database for midmarket customers.

(Hardeep Singh) XML support in DB2 Universal Database (UDB) Version 8.x is based on DB2’s relational infrastructure. Previous to the DB2 Viper release, XML data was either stored intact as a character large object (CLOB) or shredded to relational tables.

(Mike Faust) With V5R4, IBM continues its expansion of Structured Query Language (SQL) support inside of DB2 Universal Database (DB2 UDB) for iSeries. These enhancements include additional scalar and aggregate functions, new data types, support for online analytical processing (OLAP), and support fo

(Saida Davies, William Moore, Albert Chung, Qian Li Jin, Gregorio Patino and Lakshminarayanan Sreenivasan (S.L.)) This redbook shows you how to develop a JCA resource adapter based on the IBM WebSphere Adapter Architecture. The custom adapter described in this book implements the Java 2 Enterprise E

(Wei-Dong Zhu, Jorge A. Andres, Kenneth S. Christensen, Chun Liu and Glenn Dreves) This IBM Redbook deals with IBM DB2 Content Manager implementation and migration. It is aimed at architects, designers, developers, and system administrators of Content Manager systems. (pdf)

(Kent Milligan) SQL user-defined functions (UDFs) have been available since OS/400 V4R4. UDFs provide a great tool for allowing you to easily perform a business calculation as an SQL query, processing a set of rows in your database. If you want an explanation of how to implement UDFs, take a loo