In one of our earlier posts, we had covered how one can return result-sets from a stored procedure in Oracle. In this post, we are going to cover the same for DB2 LUW. DB2 LUW also does not require any variable declaration to pass back to the calling program. But we need to DECLARE the cursor first

(Judith Myerson) Explore how to develop Web services that get SAP to talk to IBM DB2 (or DB2 9) and Oracle without resulting in system overloads. This article includes examples of how you can use IBM WebSphere MQ in the development process.

(Philip Nelson) The closed and open betas of IBM’s Data Server Developer Workbench (DSDWB) 9.5 are now using the same code release (previously the closed beta had a later drop than the open beta).

(Daniel T. Chang) Model-driven software development generally starts with either application modeling or data modeling. Application modeling and data modeling, however, are closely related to, and complement, one another. IBM has recognized the importance of integrating application modeling with dat

(Willie Favero) This time though, we are going to jump up to DB2 9 for z/OS and look at a ZPARM that it is introducing. DB2 9 has been improved to use consolidated workfile space. This has tow distinct advantages that you are going to like.

(Askari Naqvi, Christian Garcia-Arellano, Haysam Alsayed and Adam Storm) Starting in IBM DB2 for Linux, UNIX, and Windows 9, a new memory tuning feature, self-tuning memory manager (STMM), simplifies the task of memory configuration by automatically setting values for several critical memory configu

(Deb Jenson) Recent high-profile data thefts have put increased pressure on companies to ensure that corporate databases are protected from intrusion. Many industry and government regulations require that proper auditing is in place to patrol data access. DB2 "Viper 2" for Linux, Unix, and Windows (

(Craig S. Mullins) Although there are a lot of nice, new features in DB2 9 for z/OS, many will be happy that IBM has improved DB2’s ability to store and manage LOB data. As anyone who has tried to use LOBs in a previous version of DB2 knows, the usability limitations were troublesome. But with Versi

(Willie Favero) Since I first started posting to this blog, I have tried to give what I thought were excellent reasons to rebind your plans and packages. Well, here’s one more reason to consider rebinding everything at some point while you are still running DB2 Version 8. Once you get to DB2 9 for z

(Eric Johnson) Follow steps to deploy, debug, and correct SQL stored procedures using IBM Database Add-ins for Visual Studio 2005. (R)