In one of our previous posts, we had covered how to return record sets from a stored procedure in the case of Oracle, SQL Server and DB2 LUW. One of the readers recently asked how to do the same with a User Defined Function. We will demonstrate that in this blog post.

(Paolo Bruni, Joel Gauci, Sabine Kaschta, Josef Klitsch, Pallavi Priyadarshini and Rajesh Ramachandran) Flexibility in business has become equal in importance with operational efficiency. Service-oriented architecture (SOA) can help businesses respond more quickly and cost-effectively to the changin

(Marina Greenstein and James Merry) In this tutorial, learn about IBM DB2 temporary tables, ADMIN_CMD procedure, savepoints and other advanced SQL features. This is the fifth in a series of six tutorials you can use to help prepare for the DB2 9.5 SQL Procedure Developer exam 735. (R)

(Robert Catterall) Recently, someone e-mailed me a portion of a DB2 monitor accounting report for an application program, and asked me if any of the numbers in the report were of the “red flag” variety (i.e., indicative of a performance problem). In responding, I mentrioned that one figure did indee

(Michael Sansoterra) In “Crunching AS/400 Data with OLAP Cubes and Excel 2000,” I outlined how to use the Pivot Table wizard with Excel 2000 (and higher) to create pivot tables from DB2 data using an ODBC data source. This TechTip will go a step further.

(Guang Xu, Wei-Dong Zhu, Mike Grasselt, Alan Mayer and Lijing Zhang) This article provides troubleshooting and debugging tips for IBM DB2 Information Integrator for Content and IBM DB2 Content Manager eClient.

(Willie Favero) On Wednesday I posted my first pair of sample questions for the DB2 System Admin Certification test, Test 737. (If you want to look at that post just go to the post “Some help preparing for the 737 Certification Test: Sample questions – Part 1”. How did did you do? Too easy, too hard

(Deepa Nadagi and Vishwas T. Mahadevaiah) In this article, learn how you can query data across heterogeneous data sources using IBM Informix Enterprise Gateway with ODBC and DRDA. After a brief introduction to the architecture and configuration of the gateway, learn how to establish a connection bet

(Leah Rosin) This fall we have been examining the power of DB2. Andrew Borts first wrote about what DB2 does on the AS/400. And Joe Pluta contributed a well-received tip comparing DB2 to SQL. Continuing with the examination of DB2 versus competing systems, and in a nod to the current political campa

(Leon Katsnelson) Recently IBM published a new TPC-C benchmark and to make a point took out a series of full page ads to tell the world about it.