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.