(Henrik Loeser) Fred Sobotka has a blog posting about how to make parameter passing from XQuery to SQL (and back) work. It details on the conditions to be met:

(Scott Hayes) I pushed my father in a wheel chair for the first time last month. As I looked at the man who was my Scout Master, who helped me achieve Eagle rank, who taught me to bowl, and inspired me with strong core values of helpfulness and community service, these wheel chair excursions marked

(Willie Favero) Although I do have one APAR for you this week, I did find quite a few OPEN APARs that I think many would find very interesting. However, they are open so all you can do right now is track them. I’ll give you a list of APAR numbers at the end of this post and when they do […]

(Jeffrey Benner) If you are using the DB2 LDAP Plug-in, you may wondering how to research whether your DB2 users have the authority to do their work. You will need to know that (A) they have an LDAP account and (B) they belong to the required LDAP groups to do their job, and not belong to groups tha

(Benjamin G. Leonhardi, Christoph Sieb and Michael J. Wurst) In the previous articles of this series, you learned different techniques for integrating InfoSphere Warehouse Data Mining and simple Cognos reports. This latest article teaches you how to use some of the same integration techniques to cre

(Craig Mullins) Many DBAs reading this blog will probably think I’m wrong, at least initially. They’ll claim that managing performance is the most important thing they do, but they are confusing frequency with importance. Yes, DBAs confront performance issues more often than they build backup plans

(Linda Hirsch) System i Access for Web enables users to access their IBM i resources and applications through a browser interface. Users can upload PC data to DB2 for IBM i, query and download database information, start a 5250 interface, work with printer output, and more. The product is running en

(Roland Barcia) Content negotiation is a key aspect to RESTful design. Here are some techniques you can use for content negotiation and how you can implement them using IBM WebSphere sMash.

(Michael Sansoterra) Part 1 and Part 2 of this little series on generating an Excel spreadsheet demonstrated how to use Visual Basic for Applications (VBA) code to retrieve data from DB2 on an AS/400 and place it in a spreadsheet. Additional refinements were offered on doing some fancier things to t

(Marina Greenstein and Maria Schwenger) In this tutorial, learn about the most common IBM tools available to develop database code. Get an overview of Visual Explain (from within the IBM DB2 Control Center and Command Editor and from within IBM Data Studio), learn about the profiling capabilities in