From: midrange-l-bounces@xxxxxxxxxxxx [mailto:midrange-l-
bounces@xxxxxxxxxxxx] On Behalf Of Wilt, Charles
Sent: Wednesday, July 23, 2008 8:47 AM
To: Midrange Systems Technical Discussion
Subject: RE: SQL Query : Fetch Next 10 rows
How are you running the query and what are you doing with the data?
For what you are trying to do, a cursor with a block fetch is probably a
exec SQL declare cursor C1 for 'Select * from faplo';
exec SQL fetch C1 for 10 rows into :myArray;
This technique would be useful in a green screen subfile program.
If you want similar results in another environment, you'll probably have
to handle things differently.
This mailing list archive is Copyright 1997-2014 by MIDRANGE dot COM and David Gibbs as a compilation work. Use of the archive is restricted to research of a business or technical nature. Any other uses are prohibited. Full details are available here. If you have questions about this, please contact