(Roger Sanders) This tutorial introduces you to embedded SQL programming and walks you through the basic steps of constructing an embedded SQL application. The tutorial also introduces you to the process used to convert one or more high-level programming language source code files containing embedde

(David Beulke) The improvements in DB2 Universal Database (UDB) for z/OS version 8 have enhanced DB2’s data warehousing capabilities on the z/OS platform. Like a high-performance car, DB2 has been turbo-charged with SQL enhancements, new table-design options, and new indexing choices. These features

(Kulvir Singh Bhogal) This article uses a real-world example to show you how to use large object data types with DB2 Universal Database in your Java development.

(Abdul H. Al-Azzawe) DB2 Version 8 ships with a great data access layer tutorial specifically designed to introduce the DB2 Development Add-In for Visual Basic 6.0 tooling and its automated ADO code generation features that will greatly simplify your multi-tier project development.

(George Baklarz, Bill Wong) DB2 databases can be accessed by applications that run on the same machine as the database or from a remote machine by using a distributed connection. In addition to providing client access to a centralized database running on a server, distributed connections can also be

As of Version 7, the EXEC SQL utility control statement can be used to declare cursors and execute dynamic SQL statements during the execution of a DB2 utility. The EXEC SQL control statement produces a result table when you specify a cursor. The EXEC SQL control statement executes entire

I come from a mainframe background, so my DB2 Universal Database (UDB) disaster recovery plan is designed to re-create my current running environment exactly as is on a recovery site machine. From my research, DB2 UDB in the Microsoft Windows 2000 environment seems slanted more toward failover than

(Craig Mullins) Speeding the retrieval of data from DB2 tables is a frequent requirement for DBAs and performance analysts. One way to accomplish this is to denormalize DB2 tables. The opposite of normalization, denormalization is the process of putting one fact in many places. This speeds data retr

(C. M. Saracco, Jacques Labrie and Julien Muller) Using Enterprise Information Integration (EII) technology to develop portal application components that integrate data from disparate sources can simplify design issues and cut coding requirements by 50 percent or more. In this article, we’ll explain

(Bonnie Baker) In the last issue of DB2 Magazine I began writing about the program preparation process for DB2 Universal Database (UDB) for OS/390 and z/OS. If you haven’t read Part 1, please do so now. Part 2 will make much more sense if you do. If you’re still confused after reading Parts 1 and 2,