(Chris Eaton) Let’s start off the year with some helpful SQL. First I want to talk about a new feature that was shipped in 8.1.4. As of this release, you can perform INSERT, UPDATE and DELETE statements on the results of a fullselect. You have always been able to put a WHERE clause on a DELETE state

(Sanjeev, Saurabhi Singh and Siddharth Singh) Over years of performance tuning endeavors, we’ve encountered many performance myths, ideologies, and traditional approaches to working with relational databases. We believe that the need of the hour is not to tune for performance, but to manage applicat

(James Chamberlain, Corinne Blanchard, Sam Burlingame, Sarika Chandramohan, Eric Forestier, Gary Griffith, Mary Lou Mazzara, Subu Musti, Sung-Ik Son, Glenn Stump and Christoph Weiss) This Redbook explains the key products and components included in the WebSphere RFID solution, with a focus on WebSph

(Paul C. Zikopoulos) This article gives readers an introduction to the Automatic Client Reroute facility that was first introduced in DB2 V8.2. This facility allows client applications to transparently connect to a standby server without exposing a communications error to the client applications.

(Mark A. Baldridge) IBM UniVerse DBA and developers need a tool to help understand how the decisions about database operations and constructs affect performance. This tutorial introduces the UniVerse Profiler for constructing, running, and reporting tests which investigate the performance impact of

(Willie Favero) While watching ER last night (Thursday) on TV, I commented on the “foreign” language the doctors and nurses spoke in the emergency room. It sounded like a bunch of meaningless garble. My daughter quickly pointed out to me that I must not listen to myself talk very often. She is so co

(Marina Greenstein) Learn how to write simple Perl programs that extract or manipulate data stored in IBM DB2 Universal Database (DB2 UDB). You will go from the simple task of selecting a row from a database into a Perl program, to more advanced topics, including dealing with large objects and invok

(Sonali Surange) IBM tooling for Visual Studio 2005 greatly simplifies the task of building Windows applications and Web sites that access DB2 Universal Database (DB2 UDB). IBM tooling provides deep integration for DB2 connections in Microsoft Server Explorer. It allows you to use existing Visual St

(Nagraj Alur, Neale Armstrong, Tadakatsu Azuma, Christian Daser and Manuel Mueller) This IBM Redbook provides an overview of IBM’s event publishing solution delivered via its WebSphere Information Integrator Classic Event Publisher and WebSphere Information Integrator Event Publisher products, and

(Jacques Roy) IBM Informix Dynamic Server has several functions that manipulate date and datetime types. You can exploit these functions to provide better processing and analysis of your business data. You can also add new functions that will simplify the solution of some date-based business problem