Execute a mysql stored procedure in a loop for each row

Anonymous — Sat, 16 Nov 2024 02:25:34 GMT

Good morning,

I have a job in Talend where the functionnal reference of my table is created via a stored procedure. The job is quite simple: get data from table A and insert it in a table B, with a new reference created for each row in table B.

I use a tMYSQLSP to call my stored procedure.

The reference is create in tMap component by concatening the creation_Date + the output of the stored procedure [ TalendDate.formatDate("yy",row1.DATECRE) + "-" + String.format("%05d", row2.num_ordre) ]

However, the stored procedure is only execute once. I then have the same reference for each row of table B, which is not good.

How can I make the stored procedure to be executed for each row of table A ?

Thank you

Re: Execute a mysql stored procedure in a loop for each row

manodwhb — Mon, 18 May 2020 04:57:54 GMT

@Moe , you can use tFlowtoiterate between table A and procedure. but I am not sure how it is gone get matching data since the procedure looks and not the main.

topic Execute a mysql stored procedure in a loop for each row in Talend Studio

Execute a mysql stored procedure in a loop for each row

Re: Execute a mysql stored procedure in a loop for each row