RE: Toying about with SQL, and just wondering

["Takken, Cor" <cor.takken@xxxxxxxxxxxxx>]

Thanks for the head-up, I appreciate it. However, that doesn't answer my
question (which is probably worded iffy):

In my view of the SQL at this moment the cursor is nothing but a method
of 'browsing' through the resultset. In order to browse the resultset
must be populated first. So when I ask for 1 or a number of rows from
the resultset I ask from a resultset which has been filled with
1.000.000 rows when opening my cursor, resulting in a number of seconds
(minutes, hours, depending on the speed of the machine) of waiting time
before the data is actually returned. My question did not concern the
method of getting data from the resultset, but concerns the filling of
the resultset. Basically I want to 'suspend' the filling of the
resultset until the data is actually needed for a limitted number of
rows (again to limit the waiting time for the user). 

The question is the result of the yearlong working with 'semi'static
subfiles where the data is read into the subfile records on a page-down
(but only one page ahead).

Cheers,

Cor

> -----Original Message-----
> From: rpg400-l-bounces@xxxxxxxxxxxx 
> [mailto:rpg400-l-bounces@xxxxxxxxxxxx] On Behalf Of McCully, 
> Keith (RBS Insurance)
> Sent: woensdag 8 november 2006 11:33
> To: 'RPG programming on the AS400 / iSeries'
> Subject: RE: Toying about with SQL, and just wondering
>
> If you're ok with SQL cursors then you can use the FETCH 
> statement to retrieve rows from a table.
>
> You can then add the multiple-row-fetch clause to control the 
> size of the result set:
>
> FOR n ROWS INTO MyStructure
>
> Where: n is the integer number of rows that you want to load,
>  
> MyStructure is (in RPG) a multi-occur data structure host 
> variable formatted in accordance with the data retrieved from 
> the table. The number of occurrences should be equal or 
> greater than the number of rows retrieved.
>
> Note that if you want to capture the actual number of rows 
> actually loaded (could be less than your chosen value for 
> n)use the SQLERR3 (ROW_COUNT) from the included SQLCA Data Structure.
>
> Cheers,
>
> Keith
>
> -----Original Message-----
> From: rpg400-l-bounces@xxxxxxxxxxxx 
> [mailto:rpg400-l-bounces@xxxxxxxxxxxx]
> Sent: 08 November 2006 06:27
> To: RPG programming on the AS400 / iSeries
> Subject: Toying about with SQL, and just wondering
>
> *** WARNING : This message originates from the Internet ***
>
> Goodday fellow-listers,
>
> I am toying about with SQL, just because I am not too 
> familiar with SQL as a database I/O method and I want to gain 
> knowledge on this area.
> During this I was playing about with the various parts that 
> can be filled by file I/O: header part, main screen and 
> subfile. Now I think I have the idea about preparing 
> statements and executing them, and even the part in which you 
> 'connect' them to a cursor. But then I wondered:
> say that a file would produce a large result set (for the sake of
> argument: 1.000.000 rows), and I wanted to fill a subfile 
> with just 10 rows at a time; do I have to wait until all 
> 1.000.000 records have been placed in the result set before I 
> can begin building the subfile? Or is it possible to fill the 
> resultset with, say, 100 records at a time and continue this 
> 'at will'?
>
>
> Kind regards,
>
> Cor Takken
>
>
>
> This e-mail and any attachment is for authorised use by the intended
> recipient(s) only. It may contain proprietary material, 
> confidential information and/or be subject to legal 
> privilege. It should not be copied, disclosed to, retained or 
> used by, any other party. If you are not an intended 
> recipient then please promptly delete this e-mail and any 
> attachment and all copies and inform the sender. Thank you.
> --
> This is the RPG programming on the AS400 / iSeries (RPG400-L) 
> mailing list To post a message email: RPG400-L@xxxxxxxxxxxx 
> To subscribe, unsubscribe, or change list options,
> visit: http://lists.midrange.com/mailman/listinfo/rpg400-l
> or email: RPG400-L-request@xxxxxxxxxxxx
> Before posting, please take a moment to review the archives 
> at http://archive.midrange.com/rpg400-l.
>
>
>
> The Royal Bank of Scotland plc, Registered in Scotland No. 
> 90312. Registered Office: 36 St Andrew Square, Edinburgh EH2 2YB
>
> Authorised and regulated by the Financial Services Authority.
>
> This e-mail message is confidential and for use by the 
> addressee only. If the message is received by anyone other 
> than the addressee, please return the message to the sender 
> by replying to it and then delete the message from your 
> computer. Internet e-mails are not necessarily secure. The 
> Royal Bank of Scotland plc does not accept responsibility for 
> changes made to this message after it was sent.
>
> Whilst all reasonable care has been taken to avoid the 
> transmission of viruses, it is the responsibility of the 
> recipient to ensure that the onward transmission, opening or 
> use of this message and any attachments will not adversely 
> affect its systems or data. No responsibility is accepted by 
> The Royal Bank of Scotland plc in this regard and the 
> recipient should carry out such virus and other checks as it 
> considers appropriate.
>
> --
> This is the RPG programming on the AS400 / iSeries (RPG400-L) 
> mailing list To post a message email: RPG400-L@xxxxxxxxxxxx 
> To subscribe, unsubscribe, or change list options,
> visit: http://lists.midrange.com/mailman/listinfo/rpg400-l
> or email: RPG400-L-request@xxxxxxxxxxxx
> Before posting, please take a moment to review the archives 
> at http://archive.midrange.com/rpg400-l.