(Jean Georges Perrin) As an application developer, I love Informix Dynamic Server (IDS) 11 (which was code-named “Cheetah” before its release). Why get so excited? Because “Cheetah” brings tools that make my day-to-day life easier. I also love XML. For me, XML is the sign of a new generation of IT p

(Sam Lennon) In a previous article, I demonstrated that treating SQLCOD as a two-value field, just like a native IO on/off indicator has some inherent dangers. In this article, I encourage you to use SQLSTT instead of SQLCOD and I provide a list of the SQLSTT values that commonly occur in busine

(Amol D. Barsagade) A tried and tested backup and recovery strategy is essential in preventing data loss. A database can encounter any number of problems, including power interruptions, storage media failure, and application crashes. Each of these can result in a database failure and each failure re

(Willie Favero) I’m talking about planning for your next DB2 for z/OS upgrade. With many of you already running DB2 Version 8 for z/OS, it’s time to start getting ready for DB2 9. Yup, I’m suggesting that you start preparing your DB2 Version 8 for that eventual upgrade to DB2 9. It doesn’t matter if

In one of our previous blog post, we covered how we can use db2look utility to generate DDL. Today we will see one more use of db2look utility to obtain the database level parameters and registry variables and generate SQL to update the statistics.

(Boris Lublinsky) SOA implementation requires the creation of a significant amount of transformation code to align varied proprietary data models with the enterprise data model used by the service interfaces. In this article, learn current approaches to providing SOA data transformation and how the

(Paul Zikopoulos) In my previous article called DB2 9 and Microsoft Excel 2007: Getting the Data DB2 9, I showed you how easy it is to get data from an IBM DB2 9 data server into your Excel 2007 worksheets. I also showed you some of the neat Excel 2007 capabilities to ‘dress-up’ your data. In this a

(Bill Arledge) DB2 9 changes the pattern of new DB2 releases. Traditionally, odd-numbered releases have been much lighter in new functionality than even-numbered releases. DB2 V5 and V7 delivered new functionality but were much smaller than DB2 V6 and V8. While DB2 9 is not as big as DB2 V8 was, D

(Reginaldo Barosa) Explore a new feature in Version 7 of WebSphere Developer for System z: z/OS Database Application Generator. z/OS Database Application Generator automatically generates CICS COBOL programs that can access DB2. It also generates a Web service, as well as the Job Control Language (J

(Kent Milligan) User-defined functions (UDFs) provide programmers with a great deal of flexibility when trying to integrate business calculations with SQL requests. A UDF enables a programmer to supply their own functions to complement the built-in functions that DB2 provides for basic string manipu