The SQL JDBC step which is not returning result set column name as per specified alias i.e. Column_Alias, however the query work fine in db.
Example Query : select Column as Column_Alias from table;
Returns column name as 'Column' instead of expected 'Column_Alias'
Release : 10.6
Component : DevTest Application Test
There is a change in behavior in the DB2 drivers as per https://www.ibm.com/support/pages/db2-alias-name-behaviour-changes-latest-drivers-versions
Add parameter in JDBC URL as below:
jdbc:db2://hostname:50000/DBName:useJDBC4ColumnNameAndLabelSemantics=false;
This should allow for resultset to have the ColumnAlias.