Re: Reading the next record in SQL: is there a secret when using OFFSET?

[Javier Sanchez <javiersanchezbarquero@xxxxxxxxx>]

This is only a matter of knowing how to manage scrollable cursors.  I
remember this was hard for me at first but then it became my everyday work
:-)

JS


El mié, 4 oct 2023 a las 9:43, Dsternb (<dieter.bender@xxxxxxxxxxxx>)
escribió:

> declare a cursor like the following and open it:
>
> select * from xyz
> where key1 > 'pet'
>  or key1 = 'pet' and key2 > 'cat'
> or key1 = 'pet' and key2 = 'cat' and key3 > 'purple'
> order by key1, key2, key3
>
> each following fetch will read the next record to show.
>
> D*B
> --
> This is the Midrange Systems Technical Discussion (MIDRANGE-L) mailing list
> To post a message email: MIDRANGE-L@xxxxxxxxxxxxxxxxxx
> To subscribe, unsubscribe, or change list options,
> visit: https://lists.midrange.com/mailman/listinfo/midrange-l
> or email: MIDRANGE-L-request@xxxxxxxxxxxxxxxxxx
> Before posting, please take a moment to review the archives
> at https://archive.midrange.com/midrange-l.
>
> Please contact support@xxxxxxxxxxxxxxxxxxxx for any subscription related
> questions.