>From a very distant past, I remember the DB2 JDBC driver just dropped column aliases, looks like that still hasn't changed. Do you get a type if you leave out the alias?
On Mon, Mar 20, 2023 at 3:20 PM <holger.hym...@comline.de> wrote: > 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> > *Gesendet:* Montag, 20. März 2023 12:31 > *An:* Hymmen, Holger <holger.hym...@comline.de>; 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 ( > 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 > > > > 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 > > > *Dipl.-Inf. Holger Hymmen* > *Berater* > Healthcare > > > > 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 > > > *Dipl.-Inf.** Holger Hymmen* > *Berater* > Healthcare > > > > <https://www.iqvia.com>Learn more 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 > > >
