topic Re: Parameterized queries, how to do them. in Talend Studio

Parameterized queries, how to do them.

PD2 — Tue, 07 Jan 2014 23:27:12 GMT

I have been working with Talend 5.4.x for about 3 weeks now, awesome tool.
I have the need to execute a query that will return to me a result set of rows containing (person id, person name, person address, person invoice) for several hundred row per week.
I would like to then use the data from the result set in "where" clauses of 12 additional queries in order to create 12 data files for a customer.
I am use to using parameterized queries where a "?" is used as a place holder for a prepared select statement.
How do I accomplish something similar to parameterized queries in Talend? At a minimum I figure each of the 12 data file queries would be a subjob.
Thoughts?
Thanks
Peter

Re: Parameterized queries, how to do them.

Anonymous — Wed, 08 Jan 2014 02:55:40 GMT

Hi,
From your requirement, please check the component TalendHelpCenter:tMysqlRow with related scenario.
Best regards
Sabrina

Re: Parameterized queries, how to do them.

Anonymous — Wed, 08 Jan 2014 11:12:52 GMT

Dear Peter,
If I'm not wrong you want to use the results of your main query as a sub query resultset / condition to your 12 additional queries?
Why don't you use tMap and try joining your main query and to these 12 different queries?
You can also store your main query result in tHashMap (input and output) components, kind of temporary table.
Parameterised query is possible assigning variables to your query component, so if you are talking about 100 rows from your main query, then you are bound to iterate 100 times to get your result?
Hope this helps.
G

Re: Parameterized queries, how to do them.

Anonymous — Wed, 08 Jan 2014 12:00:02 GMT

you could also:
tMysqlRow
-> tFlowToIterate
-> tMysqlRow (with parameter from 1st query)
-> tOutputFile***

Re: Parameterized queries, how to do them.

PD2 — Wed, 08 Jan 2014 13:58:29 GMT

Dear Peter,
If I'm not wrong you want to use the results of your main query as a sub query resultset / condition to your 12 additional queries?
Why don't you use tMap and try joining your main query and to these 12 different queries?
You can also store your main query result in tHashMap (input and output) components, kind of temporary table.
Parameterised query is possible assigning variables to your query component, so if you are talking about 100 rows from your main query, then you are bound to iterate 100 times to get your result?
Hope this helps.
G

G,
I don't disagree with your idea but I am porting the SQL from Pentaho and I would rather let the database crank on the complicated SQL (SQL with outer joins, SQL subselects with outer joins on numerous table etc..).
I have and extensive SQL back round and I would rather let the SQL/Database do the work than try to do manipulations in Talend/Java.
Thanks
Peter

Re: Parameterized queries, how to do them.

PD2 — Sat, 11 Jan 2014 14:26:53 GMT

Well I have my parameterized parameterized

Re: Parameterized queries, how to do them.

_AnonymousUser — Sat, 16 Jan 2016 07:10:47 GMT

Hi,
I have a parametrized query to be used for tpostgressqlInput component.Can anyone please help me in this regard.

Re: Parameterized queries, how to do them.

Anonymous — Mon, 18 Jan 2016 08:15:36 GMT

Hi Anj,
What does your parametrized query look like?
Best regards
Sabrina