Re: SQL sort

[Dan <dan27649@xxxxxxxxx>]

In implementations I've seen here, 'XXX' is SFLPAGE value + 1.  The +1 lets
you know if there's "More..." past the current subfile page.

- Dan

On Thu, Sep 3, 2015 at 5:24 PM, Charles Wilt <charles.wilt@xxxxxxxxx> wrote:

> > What is the right way to collect a set of records equal to SFLPAGE?
>
> ​That depends...
> FETCH FIRST XXX ROWS ONLY, will limits the rows in the ODP to just the
> first XXX rows.
>
> But you'd probably want to do a block (aka multiple-row) fetch from a
> cursor:
>
> ​fetch from mycursor
> for XXX rows into :myarray;
> ​
> ​Charles​