Hi, I am new to HOP, but have been using PDI since about 2005.
We are trying to port our project to HOP 2.3.0 and are running into a problem with DB2 and JDBC 4. With the JDBC4 logic an select id as id_new from table returns id, but I still need it to return id_new. With other programs an "useJDBC4ColumnNameAndLabelSemantics=false" works. I have tried setting it under Options in the connection section, but it seems to be ignoring it. I still get id returned. I hope somebody can help me with this. Thanks in advance Holger Hymmen Dipl.-Inf. Holger Hymmen Berater Healthcare [cid:cl_logo_footer.jpg] Learn more<https://www.iqvia.com> about IQVIA Comline GmbH - an IQVIA Business Hauert 8, 44227 Dortmund T: +49 231 97575 142 | E: holger.hym...@comline.de Gesch?ftsf?hrer: Dr. Frank Wartenberg Sitz der Gesellschaft: Dortmund Registergericht & -nummer: Amtsgericht Dortmund, HRB 32636