Help with RPGLE SQL FETCH NEXT

Hi all

I have a problem with a Web Service, invoked via server windows to display
a item inventory grid. I try to explain: the RPGLE SQL program that return a
Json file, is setted for return 60 rows for time ; in RPGLE we have coded :

' OFFSET ( ' + %char(PagNum) + ' - 1) * 60 ROWS '

' FETCH NEXT 60 ROWS ONLY '

' with NC '

' FOR READ ONLY ';

it happeds that after the fetch from the cursor , the RPGLE program, for
some required rules , skip some row, and so the Json file doesn.'t contains
60 rows but 51 or 52 .. etc etc.

my questioni s : how can force (if its possible) the fetch cycle to fill the
json file with the 60 rows, also if i need to read from my cursor more than
60 rows ??



I hope my explanation was clear

Thanks in advance

Gio