topic Re: [tMSSqlSP] Stored Procedure returning multiple output tables in Talend Studio

[tMSSqlSP] Stored Procedure returning multiple output tables

Anonymous — Sat, 16 Nov 2024 11:04:21 GMT

I try using the component tMSSqlSP who work well, but, with the component tParseRecordSet, i can only get the first result of my stored procedure. this one return me two output tables with their own columns' schema.
In my tMSSqlSP, i have 2 parameters with type IN and 2 other as RECORD SET. their 2 last are object in my schema.
It is possible to map my both record set using tParseRecordSet or another component ? If yes, how can i do this ?
thank you.

Re: [tMSSqlSP] Stored Procedure returning multiple output tables

willm1 — Fri, 28 Aug 2015 14:52:17 GMT

Have you tried using two tParseRecordSet components, one for each column that maps to a ResultSet from your SP? You could split the flow as shown below.
If that does not work, you could consider 'wrapping' your MySQL SP in another SP that writes the two outputs to tmp tables that you can read separately and easily from Talend. You could pass in the names of the temp tables, read their values after, and drop them.

Re: [tMSSqlSP] Stored Procedure returning multiple output tables

Anonymous — Fri, 28 Aug 2015 15:22:10 GMT

I have no error now but i have nothing for my second RecordSet result. Each of my tParseRecordSet use their own RecordSet derived from the tMSSqlSP.
Here is my tMSSqlSP component configuration. Is it only possible to have 2 RecordSet in my configuration ? Otherwise my component must return one RecordSet who must be seperate into 2 DataTable ?
https://www.talendforge.org/forum/img/members/316269/blob.png

Re: [tMSSqlSP] Stored Procedure returning multiple output tables

willm1 — Fri, 28 Aug 2015 21:09:57 GMT

Per this topic on MySQL Docs, try to add this flag in your Additional JDBC params: CLIENT_MULTI_RESULTS=true

Re: [tMSSqlSP] Stored Procedure returning multiple output tables

Anonymous — Mon, 31 Aug 2015 14:15:51 GMT

Did not work too.
We decided to work different with our stored procedure with temp table, map and filter row.
Thanks for the help.