Re: Help with RPGLE SQL FETCH NEXT

[Luca Giammattei <luca.giammattei@xxxxxxxxx>]

Il 10/02/2026 15:25, gio.cot via RPG400-L ha scritto:
> 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

Be aware of cursor definition, sensitive vs insensitive could make a big difference.