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'
All supported DevTest releases.
There is a change in behavior in the DB2 drivers as per DB2 Alias name behaviour changes with latest drivers versions
Add parameter in JDBC URL as below:
jdbc:db2://hostname:50000/DBName:useJDBC4ColumnNameAndLabelSemantics=false;
This will allow for resultset to have the ColumnAlias.