It worked Hans, thank you very much for your tip, it simply solved my problem.
very grateful to you Em qui., 15 de mai. de 2025 às 10:27, Hans Van Akelyen < [email protected]> escreveu: > Hi, > > You could try adding columnLabelForName=true as one of the options to the > connection. > > Kr, > Hans > On 15 May 2025 at 15:14 +0200, Bart Maertens <[email protected]>, wrote: > > This sounds like a "feature" of your JDBC driver. I don't have any > experience with Firebird, you'll have to check their JDBC driver > documentation, but there is or used to be a similar issue with DB2. > > Regards, > Bart > > > On Thu, May 15, 2025 at 3:11 PM Irio Andre Moesch <[email protected]> > wrote: > >> Hello everyone, >> >> I'm new here, I searched here about my problem and couldn't solve it and >> would like the help of the "masters". My problem is: I'm using Apache HOP >> version 2.12 and when connecting to the Firebird database version 3.0.12 >> the output of the "table input" transformation where the queries that use >> the "coalesce()" or "cast()" functions the column names do not return the >> name that was defined in the "alias" but rather the name of the function >> that was used "CAST, CAST_1, CAST_2...". How can I solve this problem? >> >> Thank you very much >> Irio >> >
