(Mike Lehmann) In my previous column, I provided a quick tour of the Business Process Execution Language (BPEL), using a complex sample business process. Now, let’s look under the covers of BPEL and get a sense of what it takes to wire an existing Web service into a BPEL process. Rather than foc
Author: SSWUG Research
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
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
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.
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
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
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 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.
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
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