[resolved] tOracleRow and propagate ResultSet

[Anonymous]

How is "Propagate ResultSet" supposed to work?

[Anonymous]

Sorry, a part of my message went missing...
What I meant was: how can I get the resultSet to be propagated when cheking "Propagate ResultSet" when there is no ResultSet row type?

[Anonymous]

Is it a non-working option?

[Anonymous · Accepted solution]

Hello
This option is used to Propagate the recordset when you use 'select' statement on tOracleRow component, you will use a tParseRecordset after tOracleRow to parse the recordset.
See my screenshots.
Best regards

shong
Best

[Anonymous]

OK, I had missed the whole tParseRecordSet stuff! Sorry and thanks a lot.

[Anonymous]

Do you know why I cannot see you screenshot ? Regards,

[akumar2301]

https://help.talend.com/reader/hm5FaPiiOP31nUYHph0JwQ/3qGcVSDN3OTCBDp2UR_Nsw

[Anonymous]

Thanks for your help Abhishek. 

I have another question. Is it possible to store a SQL query in a txt file and then execute it in tDBRow ? 

My goal is to externalize my SQL query of my talend job.

Regards,

Quentin CHOUTEAU

[Anonymous]

I found the solution. 

Thank you very much for your help.

Regards,

Quentin