Metaprogramming in SQL (Part 1)

Metaprogramming can feel like magic. You call a function that you neither wrote nor imported from any library and, magically, it comes back with a result. Even more magical is how metaprogramming lets you do […]

db2top: The Watch feature

For the second video in this video series, we have a demonstration of the db2top Watch feature. It demonstrates capturing a single application’s SQL, capturing complete database structures to a set of files, and capturing […]

Why you should program to interfaces in SQL

With DB2 9.7’s introduction of modules and the ability to create an alias on a module, you now have the ability to program to a function or procedure’s interface rather than its implementation. Why would […]

db2top: How to change column order and preserve it in the next session

Over the next few db2top-related blog posts, I am planning to post some videos that demonstrate some of the features I wrote about in earlier posts. First up is the Change Columns Order screen and […]