(Owen Cline) This “how-to” article explains how you can use SQLJ in your Java applications as well as your J2EE applications. It covers SQLJ syntax, accessing data sources, setting up WebSphere Application Developer projects to support SQLJ, and creating and invoking DB2 stored procedures using SQLJ

(Steven Burke) The big question that IBM PeopleSoft partners are grappling with in the wake of the Oracle-PeopleSoft merger is whether Oracle will attempt to displace IBM’s DB2 and WebSphere platform with its own competing product set.

IBM announced outstanding performance results on a benchmark designed to test a system’s ability to handle complex business intelligence processing. One IBM configuration achieved the world record for the best non-clustered result in the TPC-H 100GB benchmark test. Another IBM configuration in the T

(Paul Zikopoulos) When it comes to application development, Java junkies and .Net devotees may never see eye to eye. If they’re developing for DB2, they don’t have to. DB2 UDB v.8.2 shipped earlier this year with something for every developer, regardless of platform preference. This must-read e-book

This tutorial introduces new users of IBM’s Cloudscape Database to relational database concepts through a fun and interactive game called Cloudscape Detective. (R)

(Martin Oberhofer and Joachim Stumpf) This series of three articles comprise a detailed introduction to IBM DB2 Everyplace V8.2. The authors begin with an overview of IBM’s mobile solutions, delve into the details of DB2 Everyplace, and then guide you through the necessary steps to actually create a

On any platform, good database performance depends on good design. And good design includes a solid understanding of the underlying operating system and database technology, as well as the proper application of specific strategies. (R)

IBM announced it is working with the New York Stock Exchange on a new order management and messaging system in support of its 1.6 billion shares traded daily. The system will be an example of “Extreme Availability,” relying on IBM computers, infrastructure software and engineering expertise for a ne

(Cindy Saracco) Learn how to configure DB2 II to read and write to tables and views managed by MySQL, an open source DBMS. Once you’ve done this, you’ll be able to join and union data in your MySQL database with other corporate data accessible to your DB2 II federated database. The DB2 II family

(Craig Mullins) How can I add a default to a column after I have created the table? For example: create table myemp( eno int not null constraint pk_eno primary key, ename varchar(20), ecity varchar(10)) (R)