Re: Toying about with SQL, and just wondering

-Paul

To: "RPG programming on the AS400 / iSeries" <rpg400-l@xxxxxxxxxxxx>
Sent: Wednesday, November 08, 2006 12:26 AM
Subject: Toying about with SQL, and just wondering

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.