Ok, so I had a good look at the log file myself and it seems that we misinterpreted it before. It is not a transform that is getting a row with the wrong column name, but it’s the first usage of the with “as” renamed column that is producing the error. If I do “show output fields” on the original transform that is creating the problematic column, I can see that it is not generating a type for the renamed column. As column type we get “None”. Is there anything we can do, without casting every single rename? Thanks Holger
Von: holger.hym...@comline.de <holger.hym...@comline.de> Gesendet: Montag, 20. März 2023 14:39 An: users@hop.apache.org Betreff: AW: DB2 JDBC4 No, I do not see it being added to the url. I only see the jdbc:db2://server:port/db part. I do not remember from which page my info with the url comes from, but I have found this https://www.ibm.com/support/pages/db2-alias-name-behaviour-changes-latest-drivers-versions while searching and it works fine with Squirrel, but I have tried it with a 2 as value too and it does not add the option either. We are using the fields “server host name”, “port number” and “database name” in tab general to define the connection parameters and not the manual connection url. If I try the manual connection url, I have to delete the option and I see the url I want to see, but running it does not make a difference with neiter false nor 2. It seems to ignore the setting. Kind regards Holger Von: Hans Van Akelyen <hans.van.akel...@gmail.com<mailto:hans.van.akel...@gmail.com>> Gesendet: Montag, 20. März 2023 12:31 An: Hymmen, Holger <holger.hym...@comline.de<mailto:holger.hym...@comline.de>>; users@hop.apache.org<mailto:users@hop.apache.org> Betreff: Re: DB2 JDBC4 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<mailto:holger.hym...@comline.de> (holger.hym...@comline.de<mailto: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 [cid:image001.jpg@01D95B3D.792CEBA0] 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<mailto:holger.hym...@comline.de> Geschäftsführer: Dr. Frank Wartenberg Sitz der Gesellschaft: Dortmund Registergericht & -nummer: Amtsgericht Dortmund, HRB 32636 Dipl.-Inf. Holger Hymmen Berater Healthcare [cid:image003.jpg@01D95B3D.792CEBA0] 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<mailto:holger.hym...@comline.de> Geschäftsführer: Dr. Frank Wartenberg Sitz der Gesellschaft: Dortmund Registergericht & -nummer: Amtsgericht Dortmund, HRB 32636 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
