Re: Single page subfile

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