(Susan Lawson) Achieving a true 24×7 environment is almost impossible. It is rather our cleverness at hiding outages from our users that makes us “appear” 24×7. But as requirements get stricter we are going to need more help. Maintenance aside, if our databases were static life would be great, but u

(Kent Milligan) We have files that have dates in character fields in the format “mm/dd/yy”. The dates are stored in character fields with the ‘/’ included so they can be converted to tab delimited file with the CPYTOIMP command. Under V5R1, V5R2 the dates with slashes ‘/’ converted perfectly. Now un

This course provides training using Microsoft Visual Basic .NET as an add-in with DB2 UDB V8 on Linux, Unix, and Windows. Learn how to use the Microsoft Development Environment to create DB2 UDB database applications. Design applications to create database objects, populate tables, execute queries,

(Bob Swart) This article, a follow-up to the SQL DDL article, Using Delphi code to create/drop DB2 UDB database tables, focuses on the use of SQL queries to build simple and more complex SQL SELECT queries to end up with master-detail relations. The author also examines SQL joins in detail, covering

This paper examines how to be successful on the IBM DB2 platform through the use of smart data lifecycle management techniques. It also showcases how software tools from Embarcadero Technologies automate and streamline the process of data lifecycle management, with the end result being dramatic savi

This is the first tutorial in a series of three covering the development of a mobile service technician sample application for DB2 Everyplace using Visual Studio .NET 2003 and the .NET framework. The first tutorial introduces developers to the DB2 Everyplace Synchronization client API for .NET to im

(Moira Casey) PHP (PHP:Hypertext Processor) is an open source scripting language for building Web pages. With PHP and Open Database Connectivity (ODBC) you can dynamically generate Web pages from data stored in IBM Cloudscape and Apache Derby databases. In this paper, determine how to install and co

(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

(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

(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