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

Six Stars

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

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

Eight Stars sgv
Eight Stars

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

Hi !

Never used but : this option doesn't work ?

 

Capture.PNG

 

Good luck ,

SGV

Six Stars

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

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

 

trow_advancedsetting.JPGcouldn't find the suggested option

 thanks,

CR

Eight Stars sgv
Eight Stars

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

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

This doesn't give you what you want ?

 

SGV

Six Stars

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

Nope this doesn't give the expected output.

 

Six Stars

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

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

Six Stars

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

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

 

 

 

 

Six Stars

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

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

Six Stars

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

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

 

Regards