topic Re: [resolved] Execute SQL file in Talend Studio

[resolved] Execute SQL file

Anonymous — Sat, 16 Nov 2024 10:16:03 GMT

Hello,

I have a file which contains my the SQL I need to be executed. How can I execute this query from my file in my Teradata Database? I tried to use the tJava component, but with no success, maybe because I don't know Java at all.

Can you help me with a solution?

Thank you in advance!
Lucian Sabau

Re: [resolved] Execute SQL file

JR1 — Tue, 08 Nov 2016 16:45:26 GMT

Try to store the query from the input file in a global variable:

tFileInputRaw --row1 (main)--> tConvertType --row2 (main)--> tFlowToIterate --iterate--> (your Teradata query component here)

The tFileInputRaw component will give you one output field which will contain the whole content of the file. In the SQL statement in your Teradata component, put something like ((String)globalMap.get('row2.content')). The tConvertType component is just there to convert the data of type "Object" into a "String". I am not sure if it is really necessary.

Re: [resolved] Execute SQL file

Anonymous — Wed, 09 Nov 2016 07:02:55 GMT

thanks for your feedback. It's working great!
I used tFileInputRaw - TJavaRow (to redirect the input) - tFlowToIterate - tTeradataInput. In my last component it is enough to put row1.qry (the input of tFlowToIterate component).

Have a great Day!
Lucian

Re: [resolved] Execute SQL file

Anonymous — Wed, 09 Nov 2016 07:36:28 GMT

Hi Lucian,
Great your issue is fixed. Could you please mark this topic as resolved?
Best regards
Sabrina