(Shalom Momi Sabag) This post is related to http://blog.badvised.com/2009/12/converting-number-to-words-using-sql.html

(Sonali Samantaray) This article series explains Electronic Data Interchange (EDI) transformations using WebSphere Partner Gateway V6.2. Part 2 shows you how to implement two different de-enveloping and EDI transformation operations — EDI to XML transformation, and EDI to record-oriented data (ROD)

(Keith McDonald) The db2top tool is all about showing the top sessions, bufferpools, tablespaces, etc. by some criteria. It wouldn’t be very useful if it didn’t let you choose these criteria. Fortunately, db2top lets you quickly base the order in which the data is presented on the criteria of your c

(Julian Stuhler) Last month, I promised that I’d be talking in more detail about the many performance enhancements in IBM DB2 for z/OS Version 10. I’m going to keep you hanging on for another month, as some interesting IBM lab measurements are just beginning to trickle out and I want to be able to c

(Leon Kwok) This section describes the differences in the structures of the DB2 and solidDB SQL procedures.

(Willie Favero) Instrumentation Facility Component Identifier, or more affectionately referred to as IFCID; can you think of anything more exciting to discuss on a Friday afternoon. I know I can, but then it wouldn’t be related to DB2 and more than likely not the least bit helpful to anyone. However

This video demos how DB2 z/OS Not Logged Tablespaces can reduce the log overhead of SQL Replication’s change data (CD) tables. While the focus is on log overhead, a Capture CPU savings is possible, too.

(Sreeni Paidi and Angela Carlson) The purpose of this tutorial is to show you how to enable some of the autonomic features of IBM DB2 9.7 for Linux, UNIX, and Windows, and how to automate some routine database maintenance tasks. These features and techniques are particularly useful when you are embe

(Keith McDonald) Have you ever needed to write a pair of scripts: one to create some tables, data types, or user-defined functions and a second to uninstall the same? How do you test that the uninstall script did its job and didn’t leave any database objects behind? Today, using a tool that comes wi

(Dave Beulke) The 2010 North American IDUG Conference and the IOD EMEA conference the last two weeks have really highlighted all the new functionality and features within DB2 10. The more you hear about these functions and features, the more you realize they are really going to save your company mo