This tutorial shows you how to successfully create two tables and an index using the IBM DB2 Development Add-In for Microsoft Visual Studio .NET. You can use the IBM Explorer to view a sample of the contents of the table. The IBM Explorer automatically queries the number of rows that the user specif

How do I prepare an information catalog on a multipartition database using the Manage Information Catalog wizard?

DB2 Cube Views enables faster deployment, easier management, cleaner source data (thanks to centralization of data marts) and better performance across all analytical applications. And because it’s faster and easier for end users to query, it’s also more cost-effective than competing products. T

(Alexander Kuznetsov) Whether you are prototyping to prove a concept, developing a new application from the ground up, or just studying SQL, you need test data to run your application against. This article discusses how to generate enough test data to be useful for testing with the expected dist

(Craig Mullins) My requirement is to delete the top 10 rows of a particular table on DB2. My table and data are as follows. (R)

(Bob Swart) This article shows how to build a Web server application using Kylix 3, exposing the IBM DB2 UDB SAMPLE database on the Web.

(Robert Catterall) In last quarter’s DB2 DBA column, I took you on the first leg of a tour of DB2 UDB for Linux, Unix, and Windows (LUW) conducted with mainframe DBAs in mind, but open to anyone interested in DB2 technology. That part of the tour focused on system aspects of DB2 for LUW, includi

(Cathy Lappe) It was another one of those Sunday night DB2 application implementations, complete with coffee, donuts, chocolate and dumps. My partner, Charles, was braving the cold to fetch some pizza and soft drinks for us as it was already beginning to look like a longer evening than we expected.

(Tim J. Brown) This article provides an in-depth guide to understanding how to use Web Services with DB2. You’ll learn step by step how to build the environment and how to consume Web Services. (pdf)

(Jeremy McGee) There are three principal ways to connect to IBM DB2 Universal Database (UDB) from Borland Delphi 8 for the Microsoft .NET Framework: through the old Borland Database Engine (BDE), the newer dbExpress, or the latest ADO.NET technologies. In this article, I’ll help you choose the r