Author Archives: Joachim Selke

How to Convert ISO Weeks to Dates in Oracle

Converting a date to an ISO year-week string is easy in Oracle: >SELECT TO_CHAR(DATE '2012-03-11', 'IYYY-IW') FROM dual; 2012-10 One should think that converting an ISO year-week string back to a date (denoting the first day in this week) should … Continue reading

Posted in Oracle | 19 Comments

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

Posted in XML | 6 Comments

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

Posted in DB2 | 2 Comments

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

Posted in Uncategorized | 3 Comments

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

Posted in VMware | 26 Comments

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

Posted in MATLAB | 2 Comments

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

Posted in DB2 | 5 Comments

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

Posted in Uncategorized | 3 Comments

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

Posted in DB2 | 2 Comments

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

Posted in DB2 | 6 Comments