× The internal search function is temporarily non-functional. The current search engine is no longer viable and we are researching alternatives.
As a stop gap measure, we are using Google's custom search engine service.
If you know of an easy to use, open source, search engine ... please contact support@midrange.com.



On 03-Jan-2014 01:37 -0800, Booth Martin wrote:
On 1/3/2014 2:02 AM, Nisha Ramesh wrote:

Could you pls let me know how to do rollup and down using
scrollable cursor in a single page subfile.?

In RPG, with a single page subfile the scroll bar is only useful for
paging up and down a page at a time. It's not really very useful,
except on a load-all subfile.

<<SNIP>>


FWiW: I expect the reference to _scrollable cursor_ was likely, instead of a reference to _scrolling_ with a scroll bar, with regard to the use of the SQL statically declared or dynamically prepared SQL CURSOR as the means to populate the subfile:

<http://pic.dhe.ibm.com/infocenter/iseries/v7r1m0/topic/sqlp/rbafycursortype.htm?resultof=%22scrollable%22%20%22cursor%22>
IBM i 7.1 Information Center -> Database -> Programming -> SQL programming -> Using SQL in different environments -> Using a cursor
_Types of cursors_
"SQL supports serial and scrollable cursors. The type of cursor determines the positioning methods that can be used with the cursor.

_Serial cursor_

A serial cursor is one defined without the SCROLL keyword.
...

_Scrollable cursor_

For a scrollable cursor, the rows of the result table can be fetched many times. The cursor is moved through the result table based on the position option specified on the FETCH statement. ...
..."

<http://pic.dhe.ibm.com/infocenter/iseries/v7r1m0/topic/sqlp/rbafymrfetch.htm>
_Using the multiple-row FETCH statement_
"The multiple-row FETCH statement can be used to retrieve multiple rows ..."

<http://pic.dhe.ibm.com/infocenter/iseries/v7r1m0/topic/db2/rbafzh2dclcu.htm>
_DECLARE CURSOR_
"The DECLARE CURSOR statement defines a cursor. ..."

<http://pic.dhe.ibm.com/infocenter/iseries/v7r1m0/topic/db2/rbafzpreph2.htm>
_PREPARE_
"The PREPARE statement creates an executable form of an SQL statement from a character-string form of the statement. ..."


Thus Birgitta's response regarding use of "FETCH RELATIVE n" with "FOR n ROWS" clause in conjunction with the SCROLL capable cursor for populating the single-page subfile is quite probably more germane:
http://archive.midrange.com/rpg400-l/201401/msg00006.html


As an Amazon Associate we earn from qualifying purchases.

This thread ...

Follow-Ups:
Replies:

Follow On AppleNews
Return to Archive home page | Return to MIDRANGE.COM home page

This mailing list archive is Copyright 1997-2024 by midrange.com and David Gibbs as a compilation work. Use of the archive is restricted to research of a business or technical nature. Any other uses are prohibited. Full details are available on our policy page. If you have questions about this, please contact [javascript protected email address].

Operating expenses for this site are earned using the Amazon Associate program and Google Adsense.