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 

-- 
This is the RPG programming on IBM i (RPG400-L) mailing list
To post a message email: [email protected]
To subscribe, unsubscribe, or change list options,
visit: https://lists.midrange.com/mailman/listinfo/rpg400-l
or email: RPG400-L-request-+hD5IHI5Xscn3HwCXmMcX9BPR1lH4CV8@public.gmane.org
Before posting, please take a moment to review the archives
at https://archive.midrange.com/rpg400-l.

Please contact support-FMtJrHiV//lnDLsaKlm4mFaTQe2KTcn/@public.gmane.org for any subscription related questions.