Process 200 line at a time from MysqlInput

Anonymous — Sat, 16 Nov 2024 02:18:22 GMT

Hello everyone,

I have a job were I need to retrieve and pass 200 line each time until the end of the table to a child job.

I found on the forum a solution were they used a tLoop with a step of 200 and then a query like so :

SELECT A, B, C, D FROM XXX WHERE YYY AND ROWNUM > " + String.valueOf(((Integer)globalMap.get("tLoop_1_CURRENT_VALUE")))) + " AND ROWNUM < " + String.valueOf(((Integer)globalMap.get("tLoop_1_CURRENT_VALUE"))) +200)

But I'm using a tMySQLInput and don't have the ROWNUM proper to Oracle.

Is there a way around or maybe another way to processe 200 line at a time ?

Re: Process 200 line at a time from MysqlInput

TRF — Wed, 27 May 2020 22:19:16 GMT

Use this instead:
LIMIT offset, row_count
With offset as the starting row and row_count = 200 in your case

topic Process 200 line at a time from MysqlInput in Talend Studio

Process 200 line at a time from MysqlInput

Re: Process 200 line at a time from MysqlInput