(Craig Mullins) Another useful new feature debuting in V9 is the ability to compress indexes. We’ve been able to compress DB2 data in table spaces for a long time now, either through an exit routine or with the COMPRESS table space parameter (added in DB2 V3). But before V9 we’ve never been able to

(Hernando Bedoya, Jackie Jansen, Renee Mason and Gene Cobb) DB2 Web Query for System i is a Web-based query and report writing product that replaces the IBM Query for iSeries (also commonly known as Query/400) product. IBM DB2 Web Query for System i will include the Query for iSeries technology to a

(Bin Zhou and Dorothy Wu) The WebSphere Commerce report framework is a well-designed and extendable framework that allows you to develop reports quickly and conveniently. At times you may need reports in a visual format, for example, a diagram instead of a table. In this situation, a Crystal Report

(Paul Zikopoulos) In my last article, I showed you how to get DB2 data into your Microsoft Excel 2007 (Excel 2007) worksheets. In addition, I showed you some nice formatting capabilities in Excel 2007 and how to apply them to your DB2 data. In this article, I want to show you some additional advance

(Chris Eaton) IBM’s new POWER6 based servers have a new and unique hardware capability. They have added a Decimal Floating-Point Unit (DFU) which can perform numeric manipulation in hardware for decimal data.

(Randall P. Spalten and Preethi Vishwanath) This article explains how to use the XML native data type in a non-Unicode database in DB2 Viper 2. Find tips on how to avoid substitution characters, pointers for query structuring and character reference usage, and explanations of the new utility user-de

(Troy Coleman) I’ve been traveling to DB2 regional user groups talking about DB2 partitioning and how you may want to redesign your legacy applications to take advantage of some cool new features in V8 and in V9. In these presentations, I touch on universal table space (UTS).

(Roger Sanders) Which of the following is a valid wildcard character in a LIKE clause of a SELECT statement?

(Kim Moutsos) While on vacation last week, I snagged a copy of the July 2007 issue of Vanity Fair, which delves into Africa today. The issue contains articles on Desmond Tutu’s continuing fight for equality (this one written by former U.S. president Bill Clinton), funding AIDS drugs for impoverished

(Craig Mullins) This new feature in DB2 V9 might sound like an old monster movie (Invasion of the Clone Tables!!!), but it is actually a nifty new capability for managing DB2 data availability. Cloning is basically a method of entirely refreshing all of the rows of a table while maintaining availabi