[resolved] Execute dinamic SQLs

Anonymous — Sat, 16 Nov 2024 10:17:14 GMT

Hello,

I need to execute dynamically some sql's. So the flow should be like:

tTeradataInput - tmap - tFileOutputExcel - tTeradataInput2
Basically, tTeradataInput is generating the sql based on some parameters, afterwards with tTeradataInput2 I need to execute the sql generated with tTeradataInput.

Do you have any ideas how I can do it?
Right now I have problems in converting data obtained in tFileOutputExcel (csv) to convert it into a txt file, so afterwards to read it with a tJavaRow and execute the last tTeradataInput2.

Maybe you have a simple solution. Can you please help me with an idea?

Lucian Sabau

Re: [resolved] Execute dinamic SQLs

vapukov — Wed, 02 Nov 2016 02:04:04 GMT

not sure I understand You correctly, but:
You can use tFlowToIterate for store any flow data into variables, than You can use this variables value on feature steps in SQL, like:
"SELECT col1, col2, col3 FROM "+((String)globalMap.get("v_TableName")(+" WHERE "+((string)globalMap.get(v_ParamOne))+ ... etc

topic [resolved] Execute dinamic SQLs in Talend Studio

[resolved] Execute dinamic SQLs

Re: [resolved] Execute dinamic SQLs