I want to execute a set of sql queries and i want the ouput of each query (collectively) saved into an output file.? toraclerow executes set of statements ,
but do not save results in a output file.
Any ideas are welcome.
Thank you very much for the reply. But I couldn't the find the option which you have posted. My component's advanced settings looks like this
the problem is that the tOracleRow does not provide any output, see:
I have used this component exactly one time doing an update of a special Oracle table within a Talend flow.
For selects/querying you usually use other components
What exactly do you want to do? Can´t u use a "normal" tOracleInput component e.g.?
we can have multiple toraceinput input with select query and then tunite to this multiple toracleinput.
Make sure that the schema is same in all the toracleinput component as tunite accepts identiacal schema.
toracleinput (Multiple)---> tunite --> tfileoutputdelimited.
toraclerow can be used to have multiple DML statement.
you could also do UNION SELECTS directly in the tOracleInput component within the query, if the schema is same.