(Mitchell2.24v) This article describes a small utility that can be used to reset a database to a clean state. During development of applications that use databases this may be needed quite frequently. This utility was built quickly and will therefore not win any style points, but it works for m
Other News
Using IDENTITY or ROWID column types for compound primary key
(Craig Mullins) Suppose a DB2 table does not have unique values in any column for providing a primary key. The DB2 manual recommends using an IDENTITY or ROWID column type to generate a unique value and use this column as the primary key. If I use this IDENTITY or ROWID column as part of a compo
Build a servlet-based application that executes SQL statements against a database
(Joel Murach) This tutorial shows how to use a Java servlet, a JavaServer Page (JSP), and a static Java class to create an application that can be used to interactively execute any standard SQL statement against a database that’s running on a server. You can use an application like this one to w
How to implement custom fault codes with ASP.NET Web services
This step-by-step article describes how to raise a custom exception that exposes the method for dividing two numbers in a Web service and how to create a console application that consumes the Web Service and handles the custom exception.
XML lets loose the data stream
(Alan Earls) Is XML an unstoppable tidal wave? Like most things, that depends on who you talk to. Ted Friedman, a principal analyst who covers database and business intelligence technologies at Gartner, says it’s worth recalling all the hype around the marketing of XML-enabled DBMS products two to t
How to Build a Metadata Bridge for DB2 Cube Views
(John Poelman) The DB2 Cube Views feature of DB2 makes it easier to integrate business intelligence applications with the data warehouse by sharing the multidimensional metadata between the relational database and business intelligence applications. Learn how you can enable your business intelligenc
A Database-centric Approach to J2EE Application Development
(Toon Koppelaars and Centraal Boekhuis) Building a J2EE/Java application may seem a daunting task at first. Java, object-oriented programming itself, is truly different, and cannot be compared with PL/SQL (which can be classified as an easy to learn programming language). There are many new tec
BUG: Infinite Recursion Error with Parent-Child Dimension and Custom Member
When you view data associated with a custom member of a parent-child dimension, the cell values may display as “#Err”. When you examine the cell properties of any of the custom members, you receive the following error message: Infinite recursion detected during execution of calculated member.
Tuning SQL Statements on Microsoft SQL Server 2000
This paper covers the basic techniques used to tune SELECT statements on Microsoft’s SQL Server 2000 relational database management system. We discuss the techniques available using Microsoft’s graphical user interfaces provided in Microsoft SQL Enterprise Manager or Microsoft SQL Query Analyzer
Introducing the DB2 Run-Time Client Lite in DB2 UDG ‘Stinger’
(Paul C. Zikopouos) If you’ve read my column in the last issue of this magazine, you’ve got a pretty good idea about some of the major new features coming in Stinger,’ the technology preview of the next version of IBM DB2 Universal Database (DB2 UDB) for Linux, UNIX, and Windows. I want to share