(Kulvir Singh Bhogal) There’s a good chance that your enterprise applications interact with a database. Testing your application code against a database is important in making sure that your application works as expected. And while there are certainly plenty of ways to undertake that kind of testing

(Girija Parmeshwar) The DB2 Version 9 Developer Workbench (DWB) gives you a way to easily create variations of SQL and SQLJ stored procedure packages from the Database Explorer, on a DB2 for z/OS server. DWB displays all the packages associated with a stored procedure under a package folder for

(Sam Marino) This article describes the differences between Oracle and Informix Dynamic Server (IDS) functionality and syntax. In addition to DDL, DML and overall SQL syntax, you’ll explore the differences between Oracle and Informix with regards to the use of large objects, user defined types, user

(Chris Eaton) In DB2 v8 there was a new command delivered called the RECOVER command. This command combines the restore and roll forward commands into a single statement so that you can say RECOVER DATABASE db_name TO point_in_time

(Michael Ahern) These downloadable files are screen captures of IBM DB2 Content Manager version 8.3 installations presented as Shockwave Viewlets. You may download the appropriate viewlet and graphically walk through each process step-by-step.

(Roman Melnyk) This tutorial introduces you to Structured Query Language (SQL) and helps to give you a good understanding of how DB2 9 uses SQL to manipulate data in a relational database. This tutorial is the fourth series of seven tutorials that you can use to help prepare for DB2 9 Fundamentals C

(Justin Whitney) For developers, knowing how to code to a multi-core environment is half the equation. But it’s equally important to know what tools work best in that same environment. DB2 has been running on 64-bit for a while now, and has taken especially well to SMP environments, in which multipl

(Paul McInerney) This article introduces the following IBM DB for Linux, UNIX, and Windows table design features: table partitioning, multidimensional clustering (MDC), database partitioned tables, and materialized query tables (MQT). You’ll see how these features work as a team in the context of da

(Paul McInerney) This article introduces the following IBM DB for Linux, UNIX, and Windows table design features: table partitioning, multidimensional clustering (MDC), database partitioned tables, and materialized query tables (MQT). You’ll see how these features work as a team in the context of da

(Kellen F. Bombardier) This document takes you through the steps needed to install, configure, and test a “WAIP” system. WAIP stands for Windows, Apache, Informix, and PHP. It is hoped that these steps help to ease the installation and setup of a very powerful and dynamic Web system.