After adding the option to the connection and pressing the test button is the parameter correctly added to the url?
I’m also not sure if “false” is a valid value for this setting according to the docs https://www.ibm.com/docs/en/db2/11.5?topic=SSEPGG_11.5.0/com.ibm.db2.luw.apdv.java.doc/src/tpc/imjcc_r0052607.htm its either 0,1,2 in your case it should be set to 2 Kind Regards, Hans On 20 March 2023 at 11:52:13, holger.hym...@comline.de ( holger.hym...@comline.de) wrote: 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 <https://www.iqvia.com>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
