topic Re: Read SQL Query from file in Talend Studio

Read SQL Query from file

jensej — Fri, 11 Nov 2022 14:19:23 GMT

Hi!

Im trying to import a .sql file into a variable and then use the variable inside the DBInput but can't get it to work.

Why can I only save the path or error message and not the content in the global variable?

Am I on the right track or does someone has another solution? I just want to write my sql query outside the job and then pass it into the DBInput.

InfoCraft — Fri, 11 Nov 2022 14:27:17 GMT

Hi @Jens Frejd,

Please check this post: https://community.talend.com/s/feed/0D55b00007VVDgfCAH?language=en_US

Kind regards,

😷19.

jensej — Fri, 11 Nov 2022 15:02:29 GMT

Perfect thanks!