Is it possible to provide both column name and column label in JDBC ResultSetMetadata in DB2 for queries where a real table column is not involved?
select substr('Hallo', 1) as greeting from sysibm.sysdummy1
I would like to achieve a different column label and column name for the above query.
In this case getColumnName and getColumnLabel both return the String "GREETING". I would like to set a different column label (e.g. "Begrüßung").
I use DB2 JCC4 Driver and DB2 V9. Thanks.