(Calisto Zuzarte, Robert Neugebauer, Natt Sutyanyong, Xiaoyan Qian and Rick Berger) In today’s relational databases, it is not uncommon to hear of terabyte-size databases. As it becomes necessary to store ever increasing volumes of data in a single table within the database, more people need to know

Download this white paper to discover why organizations are turning to Customer Data Integration solutions to drive multiple strategic business initiatives, and why IBM’s WebSphere Customer Center has been proven as the leading solution available today. (R)

(Rahul Kitchlu and Boris Bialek) On January 30, IBM announced the availability of DB2 Express-C, a no-charge DB2 you can use for development or production. You can even redistribute it as part of your own application bundle, part of an educational curriculum, or just to friends and colleagues (pleas

(Chris Eaton) Much like the rollup operator, the GROUP BY CUBE statement performs groupings on the columns listed to deliver subtotals and grand totals. The syntax is SELECT … FROM … WHERE … GROUP BY CUBE(column1,column2,..)

(Lisa Vaas) Don Haderle, the man known as the “father of DB2,” has signed on to be the first member of a technical advisory board being set up by ANTs Software.

(Rufus Credle) The purpose of this Redbook is to help the reader understand what is involved and identifies known issues involved in migrating a BizTalk® application into the WebSphere Business Integration Server (WBIS) environment. This Redbook deals only with migrating a BizTalk 2002 application i

In Microsoft Host Integration Server, you may receive an error message that is similar to the following when you issue an SQL query statement: Server: Msg 7356,Level 16,State 1,Line 1 OLE DB provider ‘Provider Name’ supplied inconsistent metadata for a column. Metadata information was changed at

(Marty Lurie and Aron Y. Lurie) The recent explosion of information has spawned many new technologies that help digest all these gigabytes. Most humans do best with graphical representations when trying to absorb lots of information. Geographic data, in this case from the US Census, can be visualize

(Chris McCollum, Byron Braswell, Ryan Brown, Ivor Castelino, Kevin Collins, Maria Koshkina, Anant Kumar and Chris Li) IBM WebSphere Remote Server V5.1.2.1 delivers a fully integrated platform that helps manage remote environments such as retail stores and branch offices. It is a key component of the

(C. M. Saracco) You’ve probably heard the buzz about DB2’s new Viper release — IBM’s first database management system to support both tabular (SQL-based) and hierarchical (XML-based) data structures. If you’re curious about DB2’s new “native” support for XML and want to get off to a fast start, you