topic Re: [resolved] tOracleRow and propagate ResultSet in Talend Studio

[resolved] tOracleRow and propagate ResultSet

Anonymous — Sat, 16 Nov 2024 13:44:06 GMT

How is "Propagate ResultSet" supposed to work?

Re: [resolved] tOracleRow and propagate ResultSet

Anonymous — Wed, 14 Oct 2009 15:24:13 GMT

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?

Re: [resolved] tOracleRow and propagate ResultSet

Anonymous — Thu, 15 Oct 2009 13:17:48 GMT

Is it a non-working option?

Re: [resolved] tOracleRow and propagate ResultSet

Anonymous — Fri, 16 Oct 2009 08:24:55 GMT

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

Re: [resolved] tOracleRow and propagate ResultSet

Anonymous — Fri, 16 Oct 2009 09:15:32 GMT

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

Re: [resolved] tOracleRow and propagate ResultSet

Anonymous — Mon, 04 Mar 2019 11:19:48 GMT

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

Re: [resolved] tOracleRow and propagate ResultSet

akumar2301 — Mon, 04 Mar 2019 13:51:52 GMT

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

Re: [resolved] tOracleRow and propagate ResultSet

Anonymous — Mon, 04 Mar 2019 14:20:30 GMT

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

Re: [resolved] tOracleRow and propagate ResultSet

Anonymous — Mon, 04 Mar 2019 14:31:52 GMT

I found the solution.

Thank you very much for your help.

Regards,

Quentin