Author Archives: Joachim Selke
Stripping (HTML) tags in XSLT
As there doesn’t seem to be any built-in function in XLST for stripping tags from strings (e.g., to remove all markup from a piece of HTML-formatted text), people came up with a recursive template-based solution, which has been posted several … Continue reading
Where to Download the DB2 JDBC driver
When you want to access a DB2 database from Java, you usually need IBM’s JDBC driver for DB2. In the past, I (and some other people I know) always had trouble in finding out where to download the recent version … Continue reading
Steve Jobs’ Macworld 2007 Keynote (iPhone Introduction) in High Quality
For a course about giving good presentations we are currently offering at work, I was looking for a high-quality version of Steve Jobs’ famous iPhone introduction at Macworld 2007. When searching on YouTube, I only got videos in awful resolutions. … Continue reading
VMware Workstation 7.1.2 and Fedora 14
UPDATE: VMware Workstation 7.1.3 works out of the box with Fedora 14. As always, VMware has not been able to keep up with recent changes in Linux (kernel 2.6.35 and up). This becomes apparent, when trying to run VMware Workstation … Continue reading
Running MATLAB scripts on a remote server
I often have to run some experiments with large data sets in MATLAB. Therefore, it comes handy to do this on a machine that is different from my notebook. The following bash script remotely runs a given MATLAB script called … Continue reading
DB2: How to Add an Identity Column to an Existing Table
Adding generated key columns to existing tables seems to be complicated in DB2. The following code adds a new generated primary key id to the table tablename. Granted, the code is ugly, but it works. I was not able to … Continue reading
Windows 7: Persistent Storage of Login Credentials for Samba Shares
I have a Windows 7 installation running in a VMware virtual machine. Within Windows, I mounted a network drive pointing to a Samba share within our local network, which is secured by username/password. However, although I told Windows several times … Continue reading
How to look up SQL error codes quickly in DB2
Quite regularly DB2 complains about my SQL statements and usually returns a cryptic error message including an even more cryptic SQL error code. What I normally do in those situations is looking up the error code in the DB2 Information … Continue reading
What SQL statements are currently running on my DB2 database server?
To see some detailed info about which users are currently connected to your DB2 database server (including the SQL statements they are running), you can use the following query (tested with DB2 9.7, fixpack 3a): WITH a AS (SELECT a.application_handle, … Continue reading
How to move a table to a different tablespace in DB2
Recently I had to move a table of some DB2 database to a different tablespace (building an index required a larger page size). At first, I suspected changing tablespaces to be one of those complicated operations that essentially require you … Continue reading