Execute set of sql queries and collect the results into the file

[cherishma]

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.

Thanks,

CR

[Anonymous]

Hi !

Never used but : this option doesn't work ?

Good luck ,

SGV

[cherishma]

Hi SGV,

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

couldn't find the suggested option

 thanks,

CR

[Anonymous]

It's the good option. It's just i got the french version.

This doesn't give you what you want ?

SGV

[cherishma]

Nope this doesn't give the expected output.

[sushantV]

@ris.tan Did you get the answer to this query? I am pretty in the same soup right now.

[Anonymous]

the problem is that the tOracleRow does not provide any output, see:

https://help.talend.com/reader/wDRBNUuxk629sNcI0dNYaA/CCdn1_oSeiCZt4Q2dZ1RSg

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.?

Regards

[Ganshyam]

Hello,

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.

Regards

[Anonymous]

you could also do UNION SELECTS directly in the tOracleInput component within the query, if the schema is same.

Regards