IT conservations

Today I learned that you essentially cannot concatenate ( concat, || ) nullable columns properly in DB2/SQL. To be honest, I should have kno...

 I've already shown how to create a year-month function in DB2, which - when it comes to date arithmatic - is quite straightforward, be...

I quickly needed to check the monthly progress of a certain variable over time. Problem was that those bookings/incomes are spread over the...

So for various reasons (mainly the 64bit v 32bit problem with the native driver) I changed my DB2 JDBC driver to type 4, i.e. the Universal...

With DB2 on my home PC[1] I have a service account for the DB2 instance, makes life a lot easier than trying to map it to you actual user(s...

The other day, when I had to post an important letter, I was wondering if there is any post office close to an underground station on my co...

In a hack I'm currently working on (to be published soon) I needed to calculate the distance between two locations (on the surface of o...

I ran into this problem at least twice, so here is the solution (at least for my own reference in the future): If you want to use a DB2 (UDB...

Since the announcement of Sun buying MySQL recently we (Sun) of course had a lot of conversations with customers, partners and Sun interna...

All of a sudden my netbeans would no longer connect to my DB2 UDB 8.1 database. Got me a missing package error. So I tried all the usual db2...