The standard methods with which we conduct interviews broke down unexpectedly in our haste to arrange contacts for database vendor interviews. Late in December when contact was made with IBM the confirming letter outlining the structure and content of possible questions were instead taken as the lis

(Alex Woodie) iSeries shops that don’t want to use optical libraries as secondary storage medium for their IBM DB2 Content Manager for iSeries environments have a friend in MBS Technologies. While IBM pushes optical libraries to Content Manager for iSeries users, MBS Technologies is having success s

(Paul C. Zikopoulos) In a previous series of articles, I covered the rich application development integration between the Microsoft Visual Studio .NET integrated development environment (IDE), the native IBM DB2 Universal Database (DB2 UDB) managed provider for .NET, and the .NET framework. I ha

(Kim Moutsos) Fred Sobotka spent his formative years coloring on the back of the used punch cards his father brought home from his job at UNIVAC. By junior high, he had a self-described “obsession” with programming, even teaching himself how to code in 6502 assembly language from magazine articles.

In some specific cases, DB2 either modifies some predicates, or generates extra predicates. Although these modifications are transparent to you, they have a direct impact on the access path selection and your PLAN_TABLE results. This is because DB2 always uses an index access path when it is cos

(Paolo Bruni, Patric Becker, Jan Henderyckx, Joseph Link and Bart Steegmans) Conducting business via the Web and remaining open for business 24 hours a day, seven days a week is now commonplace. Customers come in with unexpected workloads through the Web and operate in a self-service fashion with mo

(Chris Eaton) In my last posting I described the new Insert/Update/Delete from Select statement in DB2 v8.1.4. But as mentioned, even more powerful is the ability to Select directly from an Insert, update or delete statement.

Business Objects and IBM have long been the business intelligence standard for thousands of customers. With IBM DB2 v8.1 and BusinessObjects Enterprise 6, the next generation of our market leading business intelligence solutions come together to enable organizations to take advantage of new query op

(Chris Lockhart) Some things in WebSphere PortalServer work well and are well documented. Other things are well documented and work well in theory. Still other things have okay documentation and will work well when all of the WebSphere stars are aligned. Depending on your implementation, Portal Clus

(Bob Swart) In this article, we will use the Borland Data Provider for ADO.NET, which is part of Borland’s C#Builder, Delphi 8 for .NET, Delphi 2005, and the newly released Delphi 2006. The later two have both Win32 and .NET personalities, but in this article I want to focus specifically on the .NET