(Allan Tham) If you’re in the process of learning to use DB2 Express, chances are you’ve had experience with another database already, such as MySQL. This article serves as a skills transfer for existing MySQL database administrators to learn about IBM DB2 Express-C GUI administration. IBM DB2 Expre

(Vincent McBurney) I’ve received the question a few times now – what should be studied before taking a DataStage Certification exam. Here is a list of sections of manuals to study and some exercise ideas to go with it.

(Ken North) DB2 9’s “pureXML” technology is speeding development for early customers, including financial-services giant Storebrand. Explore the developer-friendly features behind the radical improvements.

(Pat Moffatt, Bruce Creighton and Jessica Cao) This tutorial describes two ways to combine data from different tables in an IBM DB2 database: by joining the tables with inner or outer joins and by using the UNION, EXCEPT, and INTERSECT operators, which take the intermediate result set from one query

(Naveen Balani and Rajeev Hathi) Learn to create a sample application that uses XML as the data persistence mechanism using DB2 9. Create a Java-based application that inserts and retrieves XML elements, using powerful DB2 9 XML features. (R)

(Chris Eaton) Have you ever done a redirected restore? Did you enjoy it? Probably not. It’s a great capability but it is not the easiest thing to do. Before I dive into it let me first explain for those not familiar with DB2 what a redirected restore is.

(Robert Brunner) Along with creating a database schema and populating tables with data, being able to selectively modify data is one of the most important skills necessary for a database developer. This article teaches you how to selectively delete or update data in an existing table and how to modi

(Shash Anand, Aileen Guan, Walfrey Ng and Madeline Fok) Imagine the number of prospective clients that are searching for goods and services, such as yours right now. Is your company’s Web site designed to ensure that prospective clients can locate your site when using a search engine? More and more

(Paul Zikopoulos) In a previous series of articles, I showed you all the great integration features between the IBM DB2 Universal Database for Linux, UNIX, and Windows Version 8.x (DB2 UDB) product and the Microsoft Visual Studio.NET 2003 integrated development environment (IDE).

(Pat Moffatt, Bruce Creighton and Jessica Cao) Through a series of simple examples, this tutorial illustrates how to retrieve data from an IBM DB2 database with standard SQL SELECT statements. This tutorial describes how to retrieve rows from a relational database table, retrieve specific columns, r