(GGZ) XML is all about its flexibility, and performance, of course, in dealing with the flexibility. XML documents that are stored in a DB2 XML column are untyped. You can specify the types in XPath expressions explicitly (using cast, such as xs:double() ) or implicitly (through operators). In many

(Jeffrey Benner) Objective: You have a set of SQL DML (or other, such as DDL) statements that you want to run as a file using the CLP db2 -f filename option. If any of the statements in the file fail, you want processing of the -f file to end, every statement executed successfully (but not yet commi

(Rajan Kumar and Brent Gross) The IBM Data Server Provider for .NET enables application developers to take advantage of the Microsoft Entity Framework and LINQ. You can easily develop data access .NET applications using one of the IBM data servers (DB2, Informix Dynamic Server, or U2), the Microsoft

(Robert Catterall) A couple of months ago, I posted an entry to this blog on the topic of cloud computing. I was spurred to write this entry by an article on cloud computing that I’d recently read in InformationWeek magazine. While I found that article to be quite interesting, I was somewhat alarmed

(Lydia Parziale, Karen Bogart, Gerard Ceruti, Anbu Govindasamy, Sabine Jaeschke, Jörg Maier, Jochen Röhrig and Jon vonWolfersdorf) The power of the IBM System z, combined with the flexibility of Linux on System z, provides the ideal platform on which to implement SAP application servers. System z pr

(Luca Amato and Stefano Marinoni) This article describes a data integration scenario using WebSphere Transformation Extender, its WebSphere Design Studio, and WebSphere DataPower SOA Appliance. A common issue with legacy systems is communicating with services that consume XML instead of their native

(Antonio Cangiano) The IBM API team just released a juicy update of the ibm_db gem. Version 1.0.5 packs support for ActiveRecord 2.3.2, which is included in the latest, recently released version of Rails, as well as being compatible with Ruby 1.9.1 (you can read this post of mine to learn why this i

(Craig Mullins) As my regular readers know, every now and then I like to share Q+A exchanges I’ve had with folks. Today, the question I was asked is as follows:

(Brian Caufield) Information Server DataStage Version 8.0 introduced the Slowly Changing Dimension (SCD) stage. This tutorial provides step-by-step instructions on how to use the SCD stage for processing dimension table changes. It also shows you how to use the output of the stage to update an assoc

(Willie Favero) A Red Alert was issued for DB2 9 for z/OS potential data loss following REORG or REBUILD INDEX in non-data sharing last March 23. I posted to Twitter when it was actually announced. I’m publishing it here also for two reasons. I want to make sure anyone not using Twitter knows abo