Process 200 line at a time from MysqlInput

[Anonymous]

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 ?

[TRF]

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