(Bishwaranjan Bhattacharjee, Sriram Padmanabhan, Timothy Malkemus, Tony Lai, Leslie Cranston and Matthew Huras) IBM’s DB2 Universal Database version 8 for Unix, Windows, and open platforms introduces a new feature called Multi-Dimensional Clustering (MDC). Multi-Dimensional Clustering provides a fl

(Alexander Kuznetsov) User-defined distinct types (UDDTs) are very useful in many situations. Let us consider a simple example and see for ourselves. (R)

(Alexander Kuznetsov) Online analytical processing (OLAP) functions are very flexible and powerful. Using them, you may come up with simple solutions to some problems that would otherwise require either iteration through one or several cursors or recursion. In some other cases it is much easier to w

(Uche Ogbuji) In the document/literal style of Web services, the schemas of the interchange formats are often based on an existing document standard. This can cause problems synchronizing WSDL files with the standard schemata. This tip shows how to use XInclude to incorporate external schema fragmen

(Sujit K. Mishra) A DB2 federated system is a distributed computing system that consists of: –A DB2 server, called a federated server. –A local database called Federated Database, which is logically within Federated Server and multiple data sources to which the federated server sends queries

(Robert Catterall) Want the skinny on database efficiency? Think lean and mean. Bigger is not always better. For someone born and raised in the great state of Texas, that’s not easy to say. It’s not even easy to type.

(Kent Milligan) Before V5R2, SQL stored procedures that contained atomic compound-statements automatically issued a Rollback statement if the procedure encountered any errors during execution and a Commit statement if the procedure executed successfully. For example, if the Delete statement fail

(Jeremy McGee) In this two-part series, we show you how to use Borland Enterprise Core Objects (ECO) in Borland C#Builder Architect to build a powerful application for IBM DB2 Universal Database (UDB) that is powered by a UML model. This second article shows how ECO can quickly build complex user in

Connie Nelin is a Distinguished Engineer in the IBM Database Advanced Technology area. She has worked for IBM since 1987 with a focus on database application development support and tooling. Connie currently has overall responsibility for application development tooling strategy, architecture and de

(Steve Jones) My company is moving towards DB2 as a standard. Not necessarily in all areas and I’m not particularly worried about SQL Server being displaced, but moving forward, most of our software is targeted for DB2. So I got stuck into an installation/admin class for a week. After a day and a ha