Re: Single page subfile

That was my first thought, too. But this is an RPG thread so I, right or wrong, decided the OP could well mean a scroll bar. Since I am a scroll bar bigot I chose to decide he wants to try out a scroll bar, too.

Now he gets a good answer, whichever he was intending. Great service David provides with these lists, imnsho.


On 1/3/2014 5:16 PM, CRPence wrote:

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