Re: Subfile cursors with SQL

I agree with Daniel. It used to be that loading all the rows just took too much time to get to the open of the subfile.

But IBM has made the machine much much faster, and at least in my current project I think the hangups on showing the first screen have to do with the way the RPG was coded before. I rolled a bunch of the code into an SQL View, and trying to make that work now.

And unless it is wildly unacceptable performance, getting the code done is quicker. That counts for a lot sometimes.

--aec


On 9/28/2022 5:38 PM, Daniel Gross wrote:

Hi Doug,

this is not so complicated - just leave the cursor open and while paging down fetch the next rows - and only close and re-open the cursor when the selection and sort criteria change - then just reload page 1 with the new cursor.

We have a skeleton at work, but I don’t think that I can share it with you. But it‘s not very complex as you can code the close cursor statement without knowing if the cursor is open - it just sets SQLCODE and you don’t have to deal with it in this case.

HTH and kind regards.
Daniel

Am 28.09.2022 um 23:19 schrieb DEnglander--- via RPG400-L <rpg400-l@xxxxxxxxxxxxxxxxxx>:

I remember attending a course awhile ago where the instructor was teaching
about [I think] loading a page-at-a-time subfile with scrollable cursors.
I cannot seem to find any handouts or notes about that.

What I am trying to do is load a small [maybe 15 lines] subfile and allow
the user to press PageDn or PageUp to get the next or prior 15 rows based
on where the cursor currently resides.

I want to keep this in SQL [as opposed to Native] because the user can
specify filtering, which is incorporated into the DECLARE CURSOR
statement.

Does anyone know of any examples or URLs that can point me in the right
direction?

Thank you,

Doug



"CONFIDENTIALITY NOTICE: This e-mail transmission (and/or the attachments accompanying it) contain confidential information belonging to the sender. The information is intended only for the use of the intended recipient. If you are not the intended recipient, you are hereby notified that any disclosure, copying, distribution or the taking of any action in reliance on the contents of the information is strictly prohibited. Any unauthorized interception of this transmission is illegal under the law. If you have received this transmission in error, please promptly notify the sender by reply e-mail, and then destroy all copies of the transmission."
--
This is the RPG programming on IBM i (RPG400-L) mailing list
To post a message email: RPG400-L@xxxxxxxxxxxxxxxxxx
To subscribe, unsubscribe, or change list options,
visit: https://lists.midrange.com/mailman/listinfo/rpg400-l
or email: RPG400-L-request@xxxxxxxxxxxxxxxxxx
Before posting, please take a moment to review the archives
at https://archive.midrange.com/rpg400-l.

Please contact support@xxxxxxxxxxxxxxxxxxxx for any subscription related questions.

Help support midrange.com by shopping at amazon.com with our affiliate link: https://amazon.midrange.com