JDBC

...

driver versions

If you get undefinably issues: Please check, if you use the correct driver that is shipped with the version from your DB2 server. DB2 is here a little bit pedantic and the client JDBC driver should match the server version.

There was also a change in the usage of getColumnLabel and getColumnName in the JDBC drivers version 4.0 and later.

...

SELECT column AS aliasName from table

With JDBC drivers vesion version 4.0 and later you will most likely not get the aliasName.

...

At a test we were not able to change this behaviour by the property useJDBC4ColumnNameAndLabelSemantics and were not able to get the aliasName.
Also the behaviour is different depending on the operating system DB2 runs on.